RE: Uppercase conversion
Wouldn't you be able to build a quick procedure that converts all lower-case
into upper-case? I did (and posted) something that converted all upper-case
into mixed-case. It could be modified to do this too..
Alberto, contact me if you want a copy of the origional procedure.
-Joseph
In article <5humif$7bq@cssun.mathcs.emory.edu>,
MICHAELS@dartinc.com (Michael Silver) wrote:
>There is a way to do searched without case sensitivity. It can be done
>with some code, but not pure SQL. If you separate all the characters in
>the string you are searching for, and then determine their upper and
>lower case equivalents, you can then plug these into an SQL. Here is an
>example:
>
>Search for "SILVER"
>
>SELECT l_name FROM cust WHERE l_name MATCHES '[Ss][Ii][Ll][Vv][Ee][Rr]'>
>This may be much slower than a normal search, but will return the proper
>rows.
>
>....Michael...
>
>}-----Original Message-----
>}From: hartleh1@westat.com [SMTP:hartleh1@westat.com]
>}Sent: Wednesday, April 02, 1997 9:29 AM
>}To: informix-list@rmy.emory.edu
>}Subject: Re: Uppercase conversion
>}
>}On Thu, 13 Mar 1997 16:25:38 GMT, albertob@flash.net wrote:
>}
>}>Hi,
>}>I am new to Informix. Does anyone knows how to convert a field to
>}>Uppercase or to make a query condition not case sensitive?
>}>
>}>Thanks
>}>Alberto
>}