Convert all data in Column to UPPER case 1

[hramos25]

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

 

[ptheriault]

SELECT UPPER(column_name)
FROM Table

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[hramos25]

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

 

[ptheriault]

Yes,

UPDATE table
SET column = UPPER(column)



- Paul
- If at first you don't succeed, find out if the loser gets anything.