Subject RE: [firebird-support] NULL in concatenate
Author Filip Křikava
Is there any UDFs that do following:

If param pased to it is NULL returns string NULL else passed param

PPARAM = udf_null_int(AGE); -- AGE is NULL


For various data types.

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Sunday, December 28, 2003 12:35 PM
Subject: RE: [firebird-support] NULL in concatenate

> Hi,
> How I can solve this expression won't be null if one of the variables
> is null (AGE is null):
> PPARAM = '''' || NAME || ''',' || AGE || ',' || POSITION;
> Thanks
> Filip
You need to test for NULL, assign either the non-null value or "" to a
variable before you concatenate the assigned variables Alan

To unsubscribe from this group, send an email to:

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at Free s/h on orders $50 or more to the US & Canada.

Yahoo! Groups Links

To visit your group on the web, go to:

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to: