topic select like search in Application Development and Automation Discussions

select like search

Former Member — Wed, 04 Nov 2009 10:21:50 GMT

HI All

i want to do select with like to string

'_%' but just the first entry like

to get _123234agggh

and not 123_456

i want to do that in the select in order to filter some values

there is a way ?

Regards

Joy

Former Member — Wed, 04 Nov 2009 10:24:15 GMT

I dint understand your question well though it sounds like quite a basic one.

kesavadas_thekkillath — Wed, 04 Nov 2009 10:33:50 GMT

Ignore

Edited by: Keshu Thekkillam on Nov 4, 2009 4:04 PM

Former Member — Wed, 04 Nov 2009 10:42:09 GMT

Hi,

I am not sure if this will work. Just try this.


'\_%'

I remember using escape sequences to negate the value of special characters.