Literal percentage symbol in rowfilter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob Oldfield - 02 Dec 2004 16:34 GMT

I have a dataview that accepts input from the user before being applied.
That's fine except where the text they want to search for includes the %
character. How do I do Fullname like '*a%b*' where I want the % handled as
an actual character?

Thanks

Reply to this Message

Claes Bergefall - 03 Dec 2004 09:18 GMT

Try enclosing it in brackets ([])
See the doc's for DataColumn.Expression for more info.

/claes

> I have a dataview that accepts input from the user before being applied.
> That's fine except where the text they want to search for includes the %
> character. How do I do Fullname like '*a%b*' where I want the % handled as
> an actual character?
>
> Thanks

Reply to this Message

Rob Oldfield - 03 Dec 2004 12:01 GMT

Perfect. Many thanks.

> Try enclosing it in brackets ([])
> See the doc's for DataColumn.Expression for more info.
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...