>Is there a simple way (without having to check all the datatypes) to get the equivalent empty value for a variable. For example
>FOO(12) ------------> 0
>FOO("abcd") --------> ""
>FOO(DATE()) --------> { }
>FOO(DATETIME()) ----> { :}
>etc.
>
>I can write FOO if I need to. Just wondering if there is already a feature in the language.
>
>Thanks......Rich
You can use the CAST() function:
nVal = CAST("" AS i)
dVal = CAST("" AS d)
cVal = CAST("" AS c)
tVal = CAST("" AS t)