You have to double each single quote inside

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

>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?