Problem with null

• Smoke

  Old Hand

  Points: 308

  More actions

  March 26, 2004 at 1:43 pm

  #110820

  Hello!!!

  It might be easy (for u) but i'm stuck on this, i have an sproc where i calculate totals, my problem is that when i have a null column i need to assign 1 to that column to keep running the operations. (eg. )

  I need to calculate a simple total

  Price * Qty

  but if qty is null it must perform the multiplication like this:

  price * 1

  How can i do that ????? i'd tryed CASE, WHILE and IF and i can not get result i need.

  I really can't find a way to do it. Please if some one can enlight me to solve this i'll really appreciate.

  Thanks in advance

  Estuardo

   

  Manifest plainness,Embrace simplicity,Reduce selfishness,Have few desires.
  Lao-t'ze.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 26, 2004 at 1:47 pm

  #500743

  You are looking for IsNull which validates a column or variable to see if null, if not the use the value otherwise assign given value.

   

  Price * IsNull(Qty ,1)

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 26, 2004 at 1:47 pm

  #500742

  Use ISNULL function.

  Check in BOL por use.

• Smoke

  Old Hand

  Points: 308

  More actions

  March 26, 2004 at 5:30 pm

  #500775

   

  Thank you both for your kind help. I did not know about that function.

  Works great!!!

  Best regards

  Estuardo

  Manifest plainness,Embrace simplicity,Reduce selfishness,Have few desires.
  Lao-t'ze.