Re: Is there any way to change case in Informix

Roland Muller <rolandm@scn.de> writes: >Hi Cho, >to answer Your question: No, there is nor an upper, neither a >lower-function with the SQL. >However you might use a workaround for a case-insensitive search: >1. field MATCHES "[Nn][Oo] [Cc][Aa][Ss][Ee]" This is a very slow proposition on a large database--plus it makes it very hard on the users. I would unload the database, run it through "tr '[a-z] '[A-Z]'" and reload it. Then modify the forms and change every text field to "UPPER" Friends don't let friends change case in isql... -- ---------------------------------------------------------------------------- Daniel James - Database Administrator djames@statsci.com Data Analysis Prod Div of MathSoft (formerly StatSci) (206) 283-8802 x284