V4RB2: isNull function

[Ivan Smahin]

Hello Claudius,

Saturday, April 9, 2005, 6:43:41 PM, you wrote:

CS> Hi,

CS> from Sybase I know follwoing

CS> isnull(FieldName,40)

CS> when FieldName is NULL result is 40 else result is FieldName

CS> do we have this in Valentina 2.0 too?


Certainly, we have such functions.
We use IFNULL for the same purpose as  isnull  in Sybase.
The one of the reason is:
isNULL is very similar to the "IS NULL" statement.

Also we have COALESCE and NULLIf in this function category.


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua