Combine null and other selection in Where clause

[drallabs]

I have a where clause looking for blanks and nulls in a column e.g.,

where column is null and column = ''

Is there a way to combine these into one where statement? I am looking for either or.

 

[ESquared]

You want or? Then use or.

where column is null or column = ''

 

[ShankarJ]

Hi!

ISNULL(Column, '') = ''

Regards

 

[gmmastros]

ShankarJ,

The code posted by ESquared is better to use. Let me explain.

If there is an index on the column, your query will not be able to use it, but the code posted by ESquared will. For a full explanation, do some reading about [google]SQL Server Sargable Query[/google].



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom