Need to replace a part of a value in Sql Server 2005 [closed]

Closed. This question needs details or clarity. It is not currently accepting answers.

---

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 9 years ago.

Improve 开发者_JS百科this question

My table name is SOFTSKILL. One of Columns is MakeID. The values in the column are,

000277755
000278143
000277738
000277051

i need to change 000 into 100, like

100277755
100278143
100277738
100277051

Anybody please help me how to do this..

---

UPDATE SOFTSKILL
SET MakeId = STUFF(MakeId,1,1,'1')
WHERE MakeId LIKE '000%'