Problem with NULLS 1

[VonFranzken]

How would I write a select to exclude both NULLs and records from a table where there is absolutly nothing in there not even the word <NULL>?

Select * from Table
WHERE table.record1 <> ???

Thanks

 

[r937]

where charcolumn > ''

this will filter out both nulls as well as empty strings

r937.com | rudy.ca

 

[mrdenny]

This will also work.

select *
from table1
where Col1 is not null
and Col1 <> ''

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[r937]

yeah, it'll work, but it's more verbose, eh ;-)

i like this part -- Col1 <> ''

wouldn't this suffice -- Col1 > ''

when have you ever seen a string value < ''



r937.com | rudy.ca