SQL Server Query

Options
taran6969
edited February 11, 2022 in Analytics #1

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

Comments

  • 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