Quote:
Originally posted by armsys
Thanks for your help. How could we get the list of the functions such as coalesce()?
Armstrong
|
See help file:
The following functions/operators (following sql convention) are available for use in the Title Expression value:
Functions
· trim (and ltrim/rtrim): trim white space from the value (or left or right side only)
· coalesce(2 more values): uses the first non-null value in the provided values, from left to right
· val(): computes the number in the leading characters of the value (i.e., 123abc = 123)
Operators
· ||: the text concatenation operator (i.e., [Last Name] || ', ' || [First Name])
Note: a NULL || anything equals NULL
· + - / * and other mathematical operators (i.e., [Some Number attribute name] * 2)