Goran Bibic

Goran Bibic

  • 478
  • 2.9k
  • 201.3k

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

Oct 14 2018 2:05 PM
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)