Multiple condition if statement
In this example, the statement determines that if the ColumnName
is blank or NULL, it will be set to unknown. To make a Logical AND condition, use "&&" instead of the "||" operator.
ISNULL(ColumnName)||TRIM(ColumnName)==""?"Unknown": ColumnName
No comments:
Post a Comment