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.

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

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

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.

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

a very strange attitude to data integrety your company has :confused:

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

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?