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