How do I specify the filter for a column with NULL value in
DataTable.Select(filter, sort) function?

string filter = "columnname=NULL"; ?

Re: filter in DataTable.Select by Kevin

Kevin
Wed Oct 18 14:49:49 CDT 2006

IsNull(columnname, replacementValue)

See
http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx
--
HTH,

Kevin Spencer
Microsoft MVP
Chicken Salad Shooter
http://unclechutney.blogspot.com

A man, a plan, a canal, a palindrome that has.. oh, never mind.

"Roy" <Roy@discussions.microsoft.com> wrote in message
news:C2B1F5DE-6F86-4957-B65F-D00A1A437311@microsoft.com...
> How do I specify the filter for a column with NULL value in
> DataTable.Select(filter, sort) function?
>
> string filter = "columnname=NULL"; ?