Solved

SQL - change table values to upper case

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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 …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now