Thanks

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