>Hi,
>
>I know this should be an easy one, but I'm completely blank.
>
>I have a table with the following value in a column/field:
>
>

exec('insert into AgentBranches ([LocationCode]) values (''CO') select * from AgentBranches where ID = scope_identity()')

>
>Note that there is only one apostrophe after "CO". I need to update this value by adding in the missing apostrophe.
>
>so my code should be:
>
>

UPDATE [cman].[dbo].[dd_tables]
>   SET [insert_command] = exec('insert into AgentBranches ([LocationCode]) values (''CO'') select * from AgentBranches where ID = scope_identity()')
> WHERE table_name = 'AgentBranches'
>

>My problem is, what do I surround the new string with? When I use single quotes I get an error about missing quote.
>
>solved
>
>

UPDATE [cman].[dbo].[dd_tables]
>   SET [insert_command] = replace(cast([insert_command] as varchar(500)), 'CO'')', 'CO'''')')
> WHERE table_name = 'AgentBranches'

Hi Frank

Parameterizing is the easiest way to deal with that.