Hello,

I am using a UDF with the following definition:

DECLARE EXTERNAL FUNCTION CIF
INTEGER, CSTRING(255), CSTRING(255)
RETURNS CSTRING(255)
ENTRY_POINT 'fn_cif' MODULE_NAME 'rfunc';

Here is what I am trying to do:

select CIF((APPLICATIONS.CID = 'N/A'), '', APPLICATIONS.ENG_TYPE || ' CID')
as CI
From APPLICATIONS

What I want is if APPLICATIONS.CID contains 'N/A', I want it to return an
empty string otherwise the concatonated value of APPLICATIONS.CID and '
CID'.

Can someone show me the light?

Thanks a million!

Kevin Lingofelter