EmptyIsNull - script and chart function

The EmptyIsNull function converts empty strings to NULL. Hence, it returns NULL if the parameter is an empty string, otherwise it returns the parameter.

Syntax:

EmptyIsNull(exp )

Scripting examples
Example	Result
EmptyIsNull(AdditionalComments)	This expression will return as null any empty string values of the AdditionalComments field, instead of empty strings. Non-empty strings and numbers are returned.
EmptyIsNull(PurgeChar(PhoneNumber, ' -()'))	This expression will strip any dashes, spaces and parentheses from the PhoneNumber field. If there are no characters left, the EmptyIsNull function returns the empty string as null; an empty phone number is the same as no phone number.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here