>I have table with 50 field and mnay of the field is empty(i.e. null).
> I am wondering is ther query to find me the column that is null??? or is
> there any other way to do so??
>
> I appreciate your help...

WHERE mycol IS NULL or mycol2 IS NULL etc...

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!