On Fri, 16 Apr 1999 11:16:43 -0700, Kevin P. O'Brien wrote:
>User will enter query string in all lower case: Output is case-insensitive search
>User enters at least one uppercase character in query: Output is case-sensitive
> search.
1. Two fields with same string, one (b) binary one not (a): ... WHERE
a='key' OR b='key'.
2. char field. WHERE a='key', then if 'key' contains at least one upper
case char, do an exact match of the result in your application, and
present only matches. Requires a little code, but saves space. Fast
unless you have very strange data with lots of lines differing only in
the case.
3. ?
-Sincerely, Fred
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)
