From: Austin Ziegler <austin@...>
Date: 2002-12-16T00:41:22+09:00
Subject: Re: strange DB problem

On Sun, 15 Dec 2002 23:38:42 +0900, Mike Campbell wrote:
>> if I use "%string%" instead of "*string*" it worked fine. I need 
to
>> check the SQL standard to see what is the standard character for
>> wildcards.
> % is the only SQL wildcard I've ever seen...  I'd assumed (uhoh)
> that it was standard.

It is standard, but it's not the only one. The two SQL wildcards
are:

  %   =>    .*
  _   =>    .

Thus, "%string%" is the same as /.*string.*/ and "str_ng" is the
same as /str.ng/.

-austin
-- Austin Ziegler, austin@halostatue.ca on 2002.12.15 at 10.39.13