How to get column list having null values

Jun 18 2011 6:44 AM

How to get column list having null values

Table1
=====

ID Name City Email
1 N1 e1
2 N2 C2
3 N3 C3 e3

I need a query to find those columns whose rows having null values.

Above, o/p will be City and Email

Don't want to use the conditions like City is null or email is null