Thomas Lockhart <lockhart@alumni.caltech.edu> el día Wed, 03 May 2000
04:12:37 +0000, escribió:
>> > If I can't get my questions answered about case sensitivity issues here
>> > (no help so far) I will most likely to use it myself.
>
>My recollection is that it involved needing non-standard
>case-insensitive LIKE comparisons to get transparent behavior with an
>existing M$ Access app. So far, we were too polite to ask why one is
>working so hard to maintain compatibility with a non-standard
>interface, rather than writing the app to be portable. But I'll ask
>now. Tim?
if tim want a LIKE to be done case-insensitive, why not doing:
select foo from table1 where upper(foo) like "%BAR%" ??
sergio