Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert all data in Column to UPPER case 1

Status
Not open for further replies.

hramos25

MIS
Nov 29, 2007
9
US
Dear Sir or Madam,

Thank you in advance...

I have a Remittance column in the Vendor table with a Upper and Lower case letters, other with lower case letter only
for example

ReoDec
madec

I want to convert all the data in the Remmittance Column to UPPER CASE. HOw can I do that?

Thanks

Jim
 
SELECT UPPER(column_name)
FROM Table

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Thanks for your response, In addition I want to update the column, would that be posible, the column is char(3) not null.

Thanks

again...

Jim
 
Yes,

UPDATE table
SET column = UPPER(column)



- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top