Skip to main content

ISNULLORWHITESPACE

Checks to see if a string is null or empty because it is full of spaces.

Syntax​

bool ISNULLORWHITESPACE(string value)

Example​

The example below uses ISNULLORWHITESPACE within an IF function to return NULL if the value is MyColumn is null or empty due to spaces, otherwise the original value from MyColumn is returned.

IF(ISNULLORWHITESPACE(MyColumn), NULL(), MyColumn)