Solved

SQL - change table values to upper case

Posted on 2011-02-14
3
713 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 50 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MSSQL Speen Degradation 4 31
Count with a subquery showing details 10 49
Problem with SQL Script - Cannot call methods on char 2 26
Job - date manual 1 35
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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