If you have requirement to filter records where some columnName is either having value Null or have WhiteSpaces or is Empty, you can use following query:
SELECT columnName
FROM tableName
WHERE TRIM(columnName) IS NULL
Similarly, if you want to get records where columnName is not Null or WhiteSpaces or Empty you can use following query:
SELECT *
FROM tableName
WHERE TRIM(columnName) IS NOT NULL
0 Comment(s)