Subject | Re: [ib-support] LIKE WILDCARD ESCAPING |
---|---|
Author | Arno Brinkman |
Post date | 2002-08-22T13:04:55Z |
Hi,
*
FROM
TableA
WHERE
FieldA LIKE '/_%' ESCAPE '/'
You written almost the solution ;-)
Regards,
Arno
> I am trying to search for the underscore charSELECT
> 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?
*
FROM
TableA
WHERE
FieldA LIKE '/_%' ESCAPE '/'
You written almost the solution ;-)
Regards,
Arno