Does the SQL92 standard have to be purchased from the ANSI Board?
Well, my actual question has to do with LIKE.  Could anyone who has a
copy of a standard send me the PATTERN syntax/meanings for LIKE in
SQL92?
	Thanks,
	-DEJ

Tue, 29 Sep 1998 09:53:45 -0500
"Jackson, DeJuan" <djackson@cpsgroup.com>
SQL92
> Does the SQL92 standard have to be purchased from the ANSI Board?

afaik, yes.

> Well, my actual question has to do with LIKE.  Could anyone who has a
> copy of a standard send me the PATTERN syntax/meanings for LIKE in
> SQL92?

Well, you may be hoping for more than is in any of your reference books,
but there isn't any more to tell :)

  % ==> match any (sub)string
  _ ==> match any single character
  everything else matches itself

In SQL92 (but not yet in Postgres; can't remember if there is a
workaround):

  LIKE 'pattern' ESCAPE 'char'

allows a single character "char" if it precedes the two pattern matching
characters to demote the "%" or "_" to act like a normal single
character. The Postgres regex stuff is much more powerful.

Sorry, I think that's it :(

                    - Tom

Tue, 29 Sep 1998 16:46:06 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] SQL92