Re: Converting character columns to uppercase

Informix UPSHIFT = Ingres UPPERCASE. HTH. At 04:42 PM 1/19/96 -0800, Kevin Hogarth wrote: >Can anyone tell me if there is an equivalent to the Ingres UPPERCASE function or, >failing that how to update all the records in a column to uppercase viz: > >UPDATE table_1 >SET col_1 = uppercase(col_1); > >Many Thanks > > -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 informix developer at large (and i mean _large_) -----------------------------------------------------------------------------