Hi,

I have inherited a database with some values in a text column that I need to change to something else. The starting values are like this:

(''HQ'', <<IntString(Cases.ID)>>)

I need to change this to

(<<Cases.LocationCode>>, <<IntString(Cases.ID)>>)

I've tried this:

select replace(cast(insert_command as varchar(max)), '''HQ''', '<<Cases.Locationcode>>')

But that leaves the single quotes in like this:

('<<Cases.LocationCode>>', <<IntString(Cases.ID)>>)

What will be the correct syntax?