A: 

If you are only using ANSI-92 Query Mode for the alternative wildcard characters (rather than the enhanced SQL DDL and DCL SQL syntax it offers) then consider using the ALIKE keyword in place of the LIKE keyword.

The advantage is that you can use the ANSI-92 Query Mode wildcard characters in either Query Mode. The slight disadvantage is that the ALIKE is officially unsupported, meaning it might disappear in a future release of the engine (though I would rate this as low risk myself).

onedaywhen  2009-11-02 13:07:15

related questions

How to load ANSI escape codes or get coloured file listing in WinXP cmd shell ?
Oracle - NULLS in foreign keys?
problems using the -ansi switch in MinGW 3.4.5
ANSI color support using Groovy on Windows XP
Best way for Parsing ANSI and UTF-16LE files using Python 2/3?
Why do no databases fully support ANSI or ISO SQL standards?
How can a text file be converted from ANSI to UTF-8 with Delphi 7?
What is ANSI format?
Unicode, UTF, ASCII, ANSI format differences
Delphi - Problem With Set String and PAnsiChar and Other Strings not Displaying
Which is better code for converting BSTR parameters to ANSI in C/C++?
What is Codepage 0?
Is there a Term::ANSIScreen equivalent for Python?
What the best resource to learn ANSI SQL?
There are a method to paging using ANSI Sql only?
How write data to a text file using ANSI format
What could go wrong if I convert ANSI encoded files to UTF-8?
ANSI 92 Recursive SQL Statement required
Advice about forming Hackers Club
Converting UTF8 to ANSI with Ruby
How do I export a Crystal Report to a Unicode text file?
How do you properly use WideCharToMultiByte
Type double byte character into vbscript file
How do I correct the character encoding of a file?
Why is this regular expression faster?