Dataview RowFilter Question

  • Thread starter Thread starter dmovva
  • Start date Start date
D

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

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

Just an idea,

Cor
 
Back
Top