Dataview RowFilter Question

[dmovva]

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]

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%'";

 

[Miha Markic [MVP C#]]

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

 

[Cor Ligthert [MVP]]

Dmovva,

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

Just an idea,

Cor