5
Answers

IF no have value (NULL), need to set 0.00 SQL

Photo of Goran Bibic

Goran Bibic

6y
685
1
Question:

If is value NULL, need to put value 0 in textbox

Some help?
  1. SELECT SUM(isnull(cast(REPLACE(TRY_CONVERT(int,TRY_CONVERT(float, iznos_bpdv),1), '#,0.00','0')AS decimal(10,2)),0.00)) as UKUPNObpdv  
  2. from mp_racun_roba  
  3. where tip_robe = 'Usluge (Generalno)' and id_fakture=105

Answers (5)