SQL

[Taggs]

Can any one help me please.

I'm after selecting rows that are blank but I'm having difficulty.

row 1 row2 row3

------------------------

Col1 A A

Col2 A A A

Col3 A A

Col4 A A B

Col5 A A B

Some of the things I've tried using sql

select * from Tablename where row3=''

select * from Tablename where row3=null

select * from Tablename where len(row3) <1

I would be after the returned record set to consist of Col1 and Col3

[ihnm]

Taggs,

Try

SELECT * FROM TableName WHERE row3 is null

If I am not mistaken, ANSI NULLS would prevent

WHERE row3 = null

from returning true, since ANSI NULLs are treated as Unknown values. If we don't know the value, we can't say it's equal to something else.. even another unknown.

Cheers,

~ihnm

[Taggs]

That worked great, thank you!