Convert to lower

hi

I have a column in my database i would like to convert to lowercase

is their a t-sql statement or something i can use so i dont have to do it manually ??

cheers!!!

Hi,

you can use theLOWER function in T-SQL.

Grz, Kris.

|||

hotsheep:

hi

I have a column in my database i would like to convert to lowercase

is their a t-sql statement or something i can use so i dont have to do it manually ??

cheers!!!

update table_name set column_name=lower(column_name) .. it will convert all ur records in column_name fields ............... to lower case

hope it will help u ...