Uppercase all rows in SQL

[chaddba]

hello Guys,
I'm working with some data within a table which all needs to be converted to capital's.
users added some data and now this looks pretty bad to work with.
How do I go about doing this ?
This is the current script I have but doesn't work.

Update DBA.ProductCodes_TB

SET Productcode_FD = 'ACW, ADC, ADD, AEQ, AGT, AFG, APP, APO, APP, DFW, FCI, FIB, FPB, FPV, FRR, ISD, PTP, RAL, RRN, UMF, VIS'

WHERE

ProductCode_FD = 'acw, adc, add, aeq, agt, afq, apn, apo, app, dfw, fci, fib, fpb, fpv, frr, isd, ptp, ral, rrn, umf, vis'


Any Ideas.

[ck9663]

hello Guys,
I'm working with some data within a table which all needs to be converted to capital's.
users added some data and now this looks pretty bad to work with.
How do I go about doing this ?
This is the current script I have but doesn't work.

Update DBA.ProductCodes_TB

SET Productcode_FD = 'ACW, ADC, ADD, AEQ, AGT, AFG, APP, APO, APP, DFW, FCI, FIB, FPB, FPV, FRR, ISD, PTP, RAL, RRN, UMF, VIS'

WHERE

ProductCode_FD = 'acw, adc, add, aeq, agt, afq, apn, apo, app, dfw, fci, fib, fpb, fpv, frr, isd, ptp, ral, rrn, umf, vis'


Any Ideas.

in my opinion just do a

set Productcode_FD = upper(Productcode_FD)

this way, all of those that are not uppercase will be converted. for those that are already uppercase, it will return the same.

don't forget to change your script that insert records to the table. you might have to keep doing this if you don't change it on that level