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:

Expand|Select|Wrap|Line Numbers

 UPDATE YourTable

set = replace(yourcolumn,'ANZ','OOO')

where yourcolulmn like 'ANZ%'

-- CK

deric

Try this:

Expand|Select|Wrap|Line Numbers

UPDATE TableName SET ColumnName = 'ABC' + ColumnName

You can research more about SQL scripting here.

deric

Quote:

Originally Posted by deric

Try this:

Expand|Select|Wrap|Line Numbers

UPDATE TableName SET ColumnName = 'ABC' + ColumnName

You can research more about SQL scripting here.

Oops.. this is very late. hehe

Reg sql query

re: Reg sql query

re: Reg sql query

re: Reg sql query

re: Reg sql query

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about