Click to See Complete Forum and Search --> : Selecting null values


sapan.shah
June 25th, 2003, 10:17 AM
How do I select records having null colums using the select method of DataSet.Tables[TableName].Select(FilterExpression)

if the value is null, the expression wont be formed.
There is an option of "Is Null", but somehow i feel, that is too crude a way to do so.

The filter expression just wont work with null / DBNull!?
Is there any other work around>?

Thanks and Regards,
Sapan.