Select statement looking for empty string not null string

[sccenterprises]

I need to find out the correct sql statement to select only fields that are empty.

 

[JamesLean]

This:

SELECT cols
FROM table
WHERE col = ''

As opposed to this:

SELECT cols
FROM table
WHERE col IS NULL

--James

 

[sccenterprises]

This is a SQL in VB 6.0 and I have tried

"Select * from Requistion where AppBy = ''"

and it just brings everything back even if AppBy has KHC in the field.

 

[Catadmin]

Try combining both statements if you also need to find the null values.

Select * from Requisition where AppBy = '' or AppBy = ' ' or AppBy is Null

Make sure to use single quotes, not double. This may be your problem. Also, I listed in my code two single quotes without a space and two single quotes *with* a space because sometimes, to a user, a space may look empty even when it's not.

Does that help?



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"