if i wanted to select all columns and to display only the rows that dont contain any data in a specific column how do i do that?

i tried this statement and it doesnt work

__________________
no signature set

-m

ISNULL() is also a function.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

As a side note, avoid using ISNULL() ON clause of a join (ie: JOIN ... ON(ISNULL()))

But yes, ISNULL() is a valid control flow function :D

__________________
Where I Ramble: http://www.iwilldomybest.com/
What I do: Zynga Game Network
Senior Software Engineer at CityVille