How to update a table column data, containing ( ' ) symble in data

I am getting error in microsoft sql server because the data I want to update is contains (‘) symbol in the data.

update Employee_table
set
brokername='Angie's Broker',
where ID=7788;

Please someome resolve the problem.

>Solution :

For single quotes used inside a string literal, you put another single quote before it. This is called "escaping" the single quote, and different sorts of escaping are quite usual in programming:

update Employee_table
set
brokername='Angie''s Broker',
where ID=7788;

Leave a Reply