I have a SQL table(CustNames) that has the following fields.
I want to make the PrefersName field the same as the Firstname.I have tried the follwing SQL command.
UPDATE CUSTNAMES SET PREFERSNAME=FIRSTNAME ;
However my problem is that it changes everything from mixed case ti uper case.
eg.., John becomes JOHN
How do I get around this ?