Thursday, October 11, 2012

Multiple condition if statement

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