Re: Case Conversions using Informix SQL

Hi Richie! I don't know a method to converting strings to UPPER. Set the fields in your forms to UPSHIFT, this helps to get right data in the future. To convert data I unload the data from table and change data with vi like this: 1,$s/a/A/g. Then I'm deleting data from the table and load table with the modified data. If you want to get a security I unload the data a second time with a different name. A other method: Write a script file and use sed to change data. Take care. Dirk Emmermacher Richie Smith schrieb: > Anyone out there know of any method of converting strings to UPPER case > using Informix SQL. > > Any help would be appreciated. > > Regards > > Richie