Oninit cdi / Archive
Talk to an expert →

Re: Searching string with mixed uppercase and lowercase

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

Joan Carles Cladellas — — source: Informix-list mailing list archive (1991-1998)

Uhhh....my version of Informix is 7.24 and UPPER/LOWER don't work. Any other idea ?? Thanks. At 04:41 PM 7/27/99, Joan Carles Cladellas wrote: > > > > > Hi, Informix Guru's. > > Anybody knows how to construct a select what ignore the upper/lowercase of > a string ? > Beginning with 7.30, you can use the upper() and lower() functions. They are built into the server. So the query becomes select name from table where upper(Name) = "JOHN";or you could use the lower() function instead. Your choice. Cheers, Dick > Examples: > > SELECT Name > FROM Table > WHERE Name = "John"> > OR > > SELECT Name > FROM Table > WHERE Name = "JOhN"> > OR > > SELECT Name > FROM Table > WHERE Name = "jOhN"> > etc... > > Thanks in advance. > Dick Snoke dsnoke@informix.com Partner Engineering 770-395-2308 Informix Software 5 Concourse Parkway Suite 1500 Atlanta, Georgia 30328

↪ replying to Joan Carles Cladellas
Richard Auslander — — source: Informix-list mailing list archive (1991-1998)

Upgrade? ;-) Rich Joan Carles Cladellas wrote: > Uhhh....my version of Informix is 7.24 and UPPER/LOWER don't work. Any > other idea ?? Thanks. > > At 04:41 PM 7/27/99, Joan Carles Cladellas wrote: > > > > > > > > > > Hi, Informix Guru's. > > > > Anybody knows how to construct a select what ignore the upper/lowercase > of > > a string ? > > > Beginning with 7.30, you can use the upper() and lower() functions. They > are built into the server. So the query becomes > select name > from table > where upper(Name) = "JOHN";> or you could use the lower() function instead. Your choice. > Cheers, > Dick > > Examples: > > > > SELECT Name > > FROM Table > > WHERE Name = "John"> > > > OR > > > > SELECT Name > > FROM Table > > WHERE Name = "JOhN"> > > > OR > > > > SELECT Name > > FROM Table > > WHERE Name = "jOhN"> > > > etc... > > > > Thanks in advance. > > > Dick Snoke dsnoke@informix.com > Partner Engineering 770-395-2308 > Informix Software > 5 Concourse Parkway > Suite 1500 > Atlanta, Georgia 30328 -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com