select Stuff('[DE01]',4,0,'0')
Update tbItemList set Tag = SUBSTRING(Tag,1,2) + '0' + SUBSTRING(Tag,3,2) WHERE DatabaseID='250'
select replace('[DE01]','[DE','[DE0') ChangedToData;
UPDATE table1 SET data = Replace(data, '0', '00')
create proc p1 as begin alter table t1 rename column [DE01] to [DE001]; alter table t1 rename column [DE02] to [DE002]; ........ end go
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)