SQL - change table values to upper case

Hi,

How can I update fields in the database so they change to the uppercase version of their values.
eg, I have assumed a function called uppercasefn would work
field names: address1 and address2
update customer
set address1 = uppercasefn(address1) ,address2 = uppercasefn(address2)

Thanks
lgreallyAsked:
Who is Participating?
 
Rajkumar GsConnect With a Mentor Software EngineerCommented:
I think
UPPER(ColumnName)
will do this
0
 
Rajkumar GsSoftware EngineerCommented:
Or
TOUPPER(ColumnName)
0
 
lgreallyAuthor Commented:
thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.