[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: forcing null values into #variables?

Steve ,
If Sybase supports NULL value in numeric field , then you can check
the variable directly instead of assigning to a numeric variable .

begin-select
.....

null &n
  if isnull(&n)
     ..............   Processing for null
  else
     ................  Processing for not-null values including 0
  end-if
from ...
end-select


Hope this helps .

Mahesh

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com