Re: silly Q : how do I turn of 'Case Sensitive' in informix ?

jeroen clarysse wrote: > > I don't even know if it is possible, but can I do a full-text SQL search > thru a table with informix ignoring case ? Something like > > select * from table where LOWER(table.field) = LOWER('WozerS!')> > thanks > > jeroen > > jeroen@hypervision.be Hi Jeroen ! Some other guys have placed a similar question in this newsgroup before. Unfortunately, there is no LOWER() function in Informix by default. The preferred solutions is to implement a stored procedure that does the job. Hope this helps ! Tschuess, Dirk -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------