SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Update exact symbol from a column
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

62 Posts

Posted - 10/31/2003 :  03:58:46  Show Profile  Reply with Quote
Dear all,

I have a question is it possible to update an exact symbol from a column?
Table A
[ID] int
[A] varchar(20) default['0000000000']

I want to update for example the 8th symbol from column [A] where id=1 as I keep the existing values of the other part of the string in column [A] e.g. 0001000100 something like that.

Thank you in advance!

The Rebel


United Kingdom
12543 Posts

Posted - 10/31/2003 :  04:18:46  Show Profile  Visit nr's Homepage  Reply with Quote
update A set A = stuff(A,8,1,'1') where ID = 1

Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Edited by - nr on 10/31/2003 04:19:11
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000