Closed tastott closed 9 years ago
Check whether or not a property value is null:
SELECT Blah FROM Thing WHERE Blah IS NOT NULL
Use a replacement value if a property value is null: ISNULL(Blah, 'Default') (TSQL-like) or SELECT Blah || 'Default' (Javascript-like) or SELECT Blah ?? 'Default' (C#-like).
ISNULL(Blah, 'Default')
SELECT Blah || 'Default'
SELECT Blah ?? 'Default'
Check whether or not a property value is null:
Use a replacement value if a property value is null:
ISNULL(Blah, 'Default')(TSQL-like) orSELECT Blah || 'Default'(Javascript-like) orSELECT Blah ?? 'Default'(C#-like).