WHERE statement - need to check if Cell is blank

[dhutton]

SQL Server 2000

How do you write your query to check for blank (empty) cells?

Need to check 3 columns. ColumnA, ColumnB and ColumnC. I need to grab the data in ColumnA ONLY if ColumnB and ColumnC is empty.

================================================== =======
SELECT ColumnA,

FROM TABLE

WHERE ColumnB = "Blank" AND ColumnC = "Blank"

================================================== =======

What is the correct syntax needed for the "WHERE" statement

Thanks

dhutton

[tifoso]

it depends on the type of field you need to elaborate more on that, it sounds like you may have char or varchar field and if it allows nulls u go by this

...
where field ='' or field is null

[dhutton]

RE: How do you write your query to check for blank (empty) cells?


What did you mean by?: or field is null

(how would you add this to the WHERE statement?


The field is "char"

So... I tried

================================================== =======
SELECT ColumnA

FROM Table_Name

WHERE COLUMNB =" AND ColumnC = " (This didnt Work)

================================================== =======

SELECT ColumnA

FROM Table_Name

WHERE COLUMNB = NULL AND ColumnC = NULL (This didnt Work)

================================================== =======

[dhutton]

Ok - I got it.

SELECT ColumnA

FROM Table_Name

WHERE ColumnB = ' ' AND ColumnC = ' '

(single quote, space, single quote)


This works for checking (Char) if cell is blank in a record