Is there any UDFs that do following:

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

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

Result:
PPARAM = "NULL"

For various data types.
Thanks
Filip

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Sunday, December 28, 2003 12:35 PM
To: firebird-support@yahoogroups.com
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:
firebird-support-unsubscribe@yahoogroups.com



------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
---------------------------------------------------------------------~->

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/