--- In ib-support@y..., "Arno Brinkman" <firebird@a...> wrote:
> 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?
>
> SELECT
> *
> FROM
> TableA
> WHERE
> FieldA LIKE '/_%' ESCAPE '/'
>
> You written almost the solution ;-)
>
> Regards,
> Arno