Re: sql scan for special characters

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

To use the LIKE predicate and be able to find strings with the wildcard 
characters, you have to escape them. You do this using an ESCAPE 
expression. You want to use a character that won't otherwise be in any 
of the values tested.

LIKE ’AAAA+%BBB%’ ESCAPE ’+’

means that it will match values that start with AAAA%BBB - the final % 
sign is a wildcard, the first one is a true % sign.

Found this in the reference manual under predicates in the language 
elements chapter (2, that is).

HTH
Vern

Musselman, Paul wrote:
> The scan for PercentSign isn't '%%%%' is it?
>
> Paul E Musselman
>