Oops, didn't intend to send this to the list. Sorry.
----- Original Message -----
From: "Ray Wurlod" <[EMAIL PROTECTED]>
Date: Sun, 04 Apr 2004 17:08:19 +1000
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Subject: RE: Modern Universe (TESTING)
> The example you specified (below) is case-SENSITIVE. It will only return rows where
> the value begins with the four upper-case letters designated. In particular, it
> will not produce the results you showed (and could never select the row with
> "SARRA"). Your query is identical to the SQL:
> SELECT fieldname FROM filename WHERE fieldname LIKE 'SARA%';
> My techniques showed how to render this into a case-insensitive search by performing
> on-the-fly conversion to upper-case. It would be just as valid to perform on-the-fly
> conversion to lower case.
> However, this conversion is done in the WHERE clause, not in the SELECT clause (or
> in the RetrieVe equivalents), so that the data values are displayed in whatever case
> they are stored.
u2-users mailing list