How to use NULL or empty string in SQL

sql sql-server null where

Select *From TableWhere (col is null or col = '')

Select *From TableWhere IsNull(col, '') = ''

sql sql-server null where

If you need it in SELECT section can use like this.

SELECT ct.ID,        ISNULL(NULLIF(ct.LaunchDate, ''), null) [LaunchDate]FROM   [dbo].[CustomerTable] ct

You can replace the null with your substitution value.

sql sql-server null where

You can simply do this:

SELECT *FROM   yourTableWHERE  yourColumn IS NULL OR yourColumn = ''

CodeHunter