Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL - change table values to upper case

Posted on 2011-02-14
3
Medium Priority
?
722 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:lgreally
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 200 total points
ID: 34893425
I think
UPPER(ColumnName)
will do this
0
 
LVL 23

Expert Comment

by:Rajkumar Gs
ID: 34893428
Or
TOUPPER(ColumnName)
0
 

Author Closing Comment

by:lgreally
ID: 34893456
thanks!
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question