use
LIKE '/_%' ESCAPE '/'

look at IB6 sql reference manuel

jemrayfield2002 a écrit :

> Hi,
>
> I am trying to search for the underscore char
> within a LIKE condition.
>
> However as underscore is a wildcard I am having
> problems.
>
> I want to escape the _ underscore something
> similar to
>
> LIKE '/_%'
>
> where / is the escape char.
>
> Does anyone know who this is done?
>
> Thanks for any pointers
> Jem
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/