UPDATE query for entire table

[Nick Bardury]

Is it possible to change the case of an entire table, as opposed to just a column at a time?

I am currently using

UPDATE TableName SET FieldName = UPPER(FieldName)

But I have a huge amount of data to convert. Any help greatly appreciated.

 

[FoFa]

Wouldn't be easier to create views against your tables and just UPPER case the data in the views?

 

[SQL_Hell]

Wouldn't be easier to create views against your tables and just UPPER case the data in the views?

seconded!

or even in the front end

 

[Nick Bardury]

I would if it was my own database, but the data is in one of our company MIS Systems. I think I'm just going to have to do it column by column. Thanks for taking the time to reply.

 

[SQL_Hell]

So they let you directly edit data but not change views/ stored procs?

a very strange attitude to data integrety your company has

 

[Kodo]

then why not use the second suggestion which is to UPPERCASE them in the front end code ?

 

[FoFa]

you are way better off typically to leave the underlying data unchange in these types of circumstance, specially if a view or easy app. change is all that is needed. Any reason you need to upper case everything all of a sudden?