Subject Re: [ib-support] LIKE WILDCARD ESCAPING
Author Arno Brinkman
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