Re: SQL query question

In an article regarding SQL query question Ruchi Patel writes: > Is there anyway you could update the lower case data into uppercase... > Is there anyway you could delete a character from the column... Although I like the sophisticated method submitted by Paul Roberts, I prefer to perform an ASCII dump of the offending records and let UNIX do the conversion, then reload the records. You may find this to be a bit faster and far less of a problem. UNIX can 'sed', 'tr', 'awk' or even 'perl' your most gruesome task with ease. It also has the advantage of taking such mundane tasks out of the database leaving it to do what it does best. The disadvantage is that you need to lock the tables from updates while the data is 'outside' being modified, or do this at a time when you know no one is using the database. If you must have more real time access then Paul's solution is best. ------------------------------------------------------------------------------ John R. Carter, Sr. Programmer/Analyst - Informix DBA Computer Sciences Corporation jcarter@nas.nasa.gov Numerical Aerodynamic Simulation 415/604-3662 NASA Ames Research Center, Moffett Field, CA 94035-1000 M/S 258-6 ------------------------------------------------------------------------------