Get record with no value
Posted: Fri Oct 08, 2004 1:36 pm
This is one of those questions where I know the answer...I just can't think of it.
I'm trying do a query that looks like this:
features1 is text
I'm trying to get all records where features1 does not have any value. I've tried != null also but no luck...Any help?
I'm trying do a query that looks like this:
Code: Select all
SELECT features1,features2 from table where features1 !=''I'm trying to get all records where features1 does not have any value. I've tried != null also but no luck...Any help?