Re: Searching string with mixed uppercase and lowercase

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