Reg sql query

[shariquehabib]

I have a SQL Table I am trying to update...I would like to add 'ABC' to the START of every value in a perticular column.

Can any one help me..

--
Sharique

[shariquehabib]

before:
ANZAED12M
ANZAED1M
ANZAED1M
ANZAED2M
ANZAED2M
ANZAED3M
ANZAED3M
ANZAED6M
ANZAED6M
ANZAED9M


after:
OOOAED12M
OOOAED12M
OOOAED1M
OOOAED1M
OOOAED2M
OOOAED2M
OOOAED3M
OOOAED3M
OOOAED6M
OOOAED6M
OOOAED9M
OOOAED9M


query:

UPDATE table_name SET column=substring(column,1,start-1) || 'values' || substring(column,4,length of column) WHERE substring(column,1,3) = 'values'

UPDATE table_name SET ric=substring(ric,1,0) || 'OOO' || substring(ric,4,30) WHERE substring(ric,1,3) = 'ANZ'

[ck9663]

Your query did not add the string but replace it. I believe this would be more efficient:

UPDATE YourTable
set = replace(yourcolumn,'ANZ','OOO')
where yourcolulmn like 'ANZ%'
 

-- CK

[deric]

Try this:

UPDATE TableName SET ColumnName = 'ABC' + ColumnName 

You can research more about SQL scripting here.

[deric]

Try this:

UPDATE TableName SET ColumnName = 'ABC' + ColumnName 

You can research more about SQL scripting here.

Oops.. this is very late. hehe