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)

> Joe,
> 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.
> Regards
> Ray

u2-users mailing list

Reply via email to