Solved

SQL - change table values to upper case

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Removing SQL Replication from Microsoft SQL Server 2008 R2 2 33
Sql Query 4 38
SQL 2008 R2 syntax 11 29
MS SQL BCP Extra Lines Between Records 2 19
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 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