Do Tulip Expressions offer any sort of isnull() function

1

In an expression, for storing data in a variable, or record, using Data Manipulation, I see several ‘built-in’ functions such as (TRIM(), LEN(), FIND(), USER_ID_TO_USER(), etc.). Is there any sort of IsNull function available for use in expressions. Like I have in SQL where I can express a conditional that returns the value if it is not null or a ‘hard-coded’ value if the field is null?? ( ie. isnull(Record,0)).

Thanks,

William

2

Hi @wkurth4008,

You can use LINK() to pass in a series of arguments and the first non-null value will be returned!

Let us know if that helps!

3

Yes, that is exactly what I wanted!!! THanks!!!

William