UPDATE query for entire table (1 Viewer)

N

Nick Bardury

Guest
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

Registered User.
Local time
Today, 14:54
Joined
Jan 29, 2003
Messages
3,672
Wouldn't be easier to create views against your tables and just UPPER case the data in the views?
 

SQL_Hell

SQL Server DBA
Local time
Today, 19:54
Joined
Dec 4, 2003
Messages
1,360
FoFa said:
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
 
N

Nick Bardury

Guest
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

SQL Server DBA
Local time
Today, 19:54
Joined
Dec 4, 2003
Messages
1,360
So they let you directly edit data but not change views/ stored procs?

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

Kodo

"The Shoe"
Local time
Today, 15:54
Joined
Jan 20, 2004
Messages
707
then why not use the second suggestion which is to UPPERCASE them in the front end code ?
 

FoFa

Registered User.
Local time
Today, 14:54
Joined
Jan 29, 2003
Messages
3,672
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?
 

Users who are viewing this thread

Top Bottom