Re: [HACKERS] Bug in LIKE ?

On Mon, 7 Jun 1999, Thomas Lockhart wrote:

> > Sure there is: \%. Of course, defaulting to ESCAPE \ rather than no
> > escape is not standards-compliant either, but it's a lot closer than
> > inventing a meaning for %% ...
>
> OK.

I thought I had seen something before about this. In the Sybase 4.9
quick reference on page 21 it says:

To use %,_,[], or [^] as literal characters in a like match string rather
than as wildcards, use square brackets as escape characters for the
percent sign, the underscore and the open bracket. Use the close bracket
but itself. Use the dash as the first character inside a set of brackets.

like "5%" 5 followed by any string of 0 or more characters
like "5[%]" 5%
like "_n" an, in, on, etc.
like "[_]n" _n
like "[a-cdf]" a, b, c, d, or f
like "[-acdf]" -, a, c, d, or f
like "[[]" [
like "]" ]

Wildcards without like have no special meaning.

That help any?

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================