Like keyword

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
Tue Jan 25 19:25:25 CST 2005

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/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclasstopic.asp



--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Patrick" <kingofusa@juno.com> wrote in message
news:emkGhZzAFHA.3840@tk2msftngp13.phx.gbl...
> 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....
>
>