Re: Convert Upper to Lower case

Peter Jakob <pjakob@io.org> writes: >Does anyone know how to convert a column of data from UPPER case to lower >case using ISQL? My purchased application is case sensative which causing a >great problem for me. 1. Use 4GL to downshift 2. If in unix environment, UNLOAD the whole table, then run the following: tr "[A-Z]" "[a-z]" from file to file ( I can't type redirects on this screen, so substitute "less than" for the word "from" above and "greater than" for "to" ) Now delete whole table and reload the data back into it. 4GL is much easier!