Replace values in table 2

[meBrian]

In a table there is a field 'id' of type 'varchar' that at one time had a prefix. I want to go in and remove that prefix from the values.

Not all values have the prefix so I will select only those records.

Example Value: A00-123456

Goal: Remove the 'A00-' from the field

Thanks for the help.

 

[SQLDenis]

use replace


declare @v varchar(50)
select @v ='A00-123456'

select replace(@v,'A00-','')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[r937]

update daTable
   set id = replace(id,'A00-','')
 where id like 'A00-%'

r937.com | rudy.ca

 

[meBrian]

Wow. Thanks for the fast response.
I was getting close but was way over thinking it.
Thanks alot to both of you.

Have a star!