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

Re: Literal percentage symbol in rowfilter by Claes

Claes
Fri Dec 03 03:18:15 CST 2004

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

/claes

"Rob Oldfield" <sfsd@sdfsdf.sdfs> wrote in message
news:eMJrUzI2EHA.3236@TK2MSFTNGP15.phx.gbl...
> 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
>
>



Re: Literal percentage symbol in rowfilter by Rob

Rob
Fri Dec 03 06:01:54 CST 2004

Perfect. Many thanks.


"Claes Bergefall" <claes.bergefall@online.nospam> wrote in message
news:uYdcHkR2EHA.1452@TK2MSFTNGP11.phx.gbl...
> Try enclosing it in brackets ([])
> See the doc's for DataColumn.Expression for more info.
>
> /claes
>
> "Rob Oldfield" <sfsd@sdfsdf.sdfs> wrote in message
> news:eMJrUzI2EHA.3236@TK2MSFTNGP15.phx.gbl...
> > 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
> >
> >
>
>