|
jimf
Flowing Fount of Yak Knowledge
USA
2865 Posts |
 Posted - 01/21/2013 : 20:22:33
|
SELECT number,[type],[TYPE] + '_OK' as NewType
FROM t_master
or if you actually want to change the values in t_master
UPDATE t_master
SET [TYPE] = [TYPE] + '_OK'
Jim
Jim
Everyday I learn something that somebody else already knew |
 |
|
problem adding suffix character
