Updating text in using SQL in a DAtabase

Question

I am very new at SQL and keep getting erors when I try to change some text in my dataqbase for every instance. I was told my syntax was incorrect:

I am tryingto change the text in the lst link to the second link.

UPDATE dbo.qanda

Is this what you are looking for? - stackoverflow.com/questions/814548/… — Chubby Boy
– Chubby Boy, Commented Jun 11, 2013 at 18:33

Fabio · Accepted Answer · 2013-06-11 18:32:50Z

2

You are using a wrong REPLACE syntax. Also check your backtick, they should be quotes instead. Try this syntax

UPDATE dbo.qanda
SET columnname = REPLACE(columnname, 'http://vhahacnonva.vha.med.va.gov/', 'http://nonvacare.hac.med.va.gov/');

Just change columnname with your actual column name.

answered Jun 11, 2013 at 18:32

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Right on the money, Fabio.