Hi all,
I was trying to use RowFilter on a DataView object. I want to seach
all the titles starting with letters a,b,c. SQL quesry would be
something like this

select * from results where title like [a-c]%

My rowfilter is
dv.RowFilter = "Title like '[a-c]%'";
but this is not working. I tried other variations too like,

"Title like '[[]a[-]c[]][%]'";

can some one help me with this please


Thanks
D

and I know the following would work but I don't want it that way

"Title like 'a%' or title like 'b%' or title like 'c%'";

Try OR-ing the conditions: title like 'a%' or title like ...

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"dmovva" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all,
> I was trying to use RowFilter on a DataView object. I want to seach
> all the titles starting with letters a,b,c. SQL quesry would be
> something like this
>
> select * from results where title like [a-c]%
>
> My rowfilter is
> dv.RowFilter = "Title like '[a-c]%'";
> but this is not working. I tried other variations too like,
>
> "Title like '[[]a[-]c[]][%]'";
>
> can some one help me with this please
>
>
> Thanks
> D
>

Dmovva,

Have you tried to add an extra column with an expression to make the
condition easier?

Just an idea,

Cor