select like search

[Former Member]

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]

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]

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

[kesavadas_thekkillath]

Ignore

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

[Former Member]

Hi,

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

'\_%'

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