Replacing data in a field
-
I have a table with account info like:
ACCT_ID
10000-01
BT000-02
ACBD0-13
I need to insert a 3 after each dash, to look like:
10000-301
BT000-302
ACBD0-313
What would be the proper command to do this?
Thanks in advance.
-
UPDATE dbo.YourTableName SET FieldName = REPLACE (FieldName, '-', '-3')
-
Thanks, worked great!
-
HTH.
-
If this is not going to be a one shot pony make sure that the UPDATE doesn't update records that are already -3....
Good Hunting!AJ Ahrens
webmaster@kritter.net -
Since we're making valid points >>
update... where charindex ('-', FieldName, 1) > 0 so that you update only the rows that need changing.
-
and if we get really picky:>>>
update... where FieldName Like '_____-%'
* Noel -
Now you're assuming that the field is indexed
. -
Yeah sometimes I like to guess a bit
* Noel -
This helped me. Thanks!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply