WITH SampleData AS (SELECT 1 AS col1, CAST(NULL AS varchar(10)) AS col2 UNION ALL SELECT 2, '' UNION ALL SELECT 3, 'hello') SELECT * FROM SampleData WHERE NULLIF(col2, '') IS NOT NULL;
Post a Comment
No comments:
Post a Comment