Posted by John Bell on 06/02/05 23:34

Hi

You don't say what the different queries produce and why they are wrong?

I would expect dv.rowfilter = " Title like '[a-j]%' " to work unless you
have a case sensitive database.

dv.rowfilter = " Title like 'a%'" AND "Title like 'b%'" AND..so on
will not work as you are using AND instead of OR

John

"vbnetrookie" <bigjmt@hotmail.com> wrote in message
news:1117739689.034013.284370@g44g2000cwa.googlegroups.com...
> In the dataview rowfilter property, how can I say that I just want
> Titles that start with 'A' to 'J' ??
>
>
> ex:
> dv.rowfilter = " Country = ' France ' "
>
>
> I want
> dv.rowfilter = " Title = (from 'A' to 'J') "
>
> This doesn't work :
> dv.rowfilter = " Title like '[a-j]%' "
>
> Neither does :
> dv.rowfilter = " Title like 'a%'" AND "Title like 'b%'" AND..so on
>
> But this does work just for the Titles starting with 'a'
> dv.rowfilter = " Title like 'a%' "
>
> any idea ?
> JMT
>

• Next in forum: Re: sql server and vpn: performance/speed
• Prev in forum: Re: Getting Data from a storeed procedure in a stored procedure
• Thread view: Re: query in dataview.rowfilter

[Reply to this message]