query to alter column data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

query to alter column data

Author

Topic

techadv
Starting Member

2 Posts

Posted - 2010-03-01 : 23:16:25

hi all,

I was hoping someone can help me out with a query, or at least point me in the right direction.

There is an "item code" column in one of my tables, and I need a query which will add a "zero" into the 3rd position of each code

OLD CODE: 12345
NEW CODE: 120345

Is this possible to do with a query? Thanks in advance.

Cheers ~

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-02 : 00:00:31

What data type is the column?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-02 : 02:42:28

Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140661

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources