| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
09-28-2006, 05:01 AM
|
|||
|
|||
T-SQL dialect question:
How do I batch check 30 fields for NULL?I have say 30 fields and would like to batch check them for NULL in one SQL statement, is there a way? Or do I have to write something like the following for each single field:
select field1 from table1 where isnull(field1);     
|
 |
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
