Any idea?

column "TEST"
data of column TEST [data123], [data234], [test111], [test321], [data456]

How can I replace part "test" to "data" by simple sql-command?

UPDATE SomeTable
SET Test = REPLACE(Test,'Test','data')

HTH, Jens Suessmeyer.

SELECT REPLACE(TEST,'test','data') from <tablename>

thank You

NESTED SQL QUESTION and aggregate function
CLR Triggers and inserted table
SQL script, split digits and letters
Concatenating:www.aspfaq.com/show.asp?id=2529 Is the glass half full or half empty or..?
Query help - resultset too large... impossible!