Like keyword

[Patrick]

Hi Group

I have one column which can be either Null or with some value.

I have one filter criteria in From End with
"All", 'RTF Yes' and 'RTF No'.
Depending on the filter selected by user i have to select the pertaining
rows as below
If Filter "All" select all rows from table
if Filter = 'RTF yes' select only rows where 'RTF yes' in rows ( where
columns in not null )
if Filter = 'RTF No' select only rows where column is null

how can i put this into where clause.
Please advice.
Thanks
Pat....

 

[W.G. Ryan eMVP]

I guess you are talking about client side on the data table? You can use an
Expression colum and the Like method
http://msdn.microsoft.com/library/d.../html/frlrfsystemdatadatacolumnclasstopic.asp