Sum if is value varchar...sum, iff is null to be 0 select dobavljac as 'Dobavljac' , SUM(isnull(cast(REPLACE(CONVERT(varchar,CONVERT( float ,iznos_sa_pdv),1)), '#,0.00' , '' ),0) AS UKUPNO) from (select dobavljac, iznos_sa_pdv from ulazni_racun_roba_lista union all select poslovni_partner, iznos_sa_pdv from mp_ulazni_racun_ostalo_lista) as alltables group by dobavljac error is Msg 174, Level 15, State 1, Line 1 The replace function requires 3 argument(s). Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'as'.

We can use as: SELECT CONVERT(Decimal(10, 4), ISNULL(NULLIF(yourcolumnname, ''), '0')) Hope its help Thanks

Thanks for quick response . Really nice.

Answers

Sum if is value varchar

Goran Bibic

571

Sum if is value varchar...sum, iff is null to be 0

select dobavljac as 'Dobavljac', SUM(isnull(cast(REPLACE(CONVERT(varchar,CONVERT(float,iznos_sa_pdv),1)), '#,0.00',''),0) AS UKUPNO)
from (select dobavljac, iznos_sa_pdv from ulazni_racun_roba_lista union all select poslovni_partner, iznos_sa_pdv from mp_ulazni_racun_ostalo_lista) as alltables
group by dobavljac

error is

Msg 174, Level 15, State 1, Line 1
The replace function requires 3 argument(s).
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'as'.