SQL Server Query

taran6969

How can we check in a SQL Server WHERE condition whether the column is not null and not the empty string ('')?

FBauza

Hi taran6969

Maybe you can use "where field_name is null" or "is not null". If the field is empty you should use "field = ''"

I hope it is useful