Update in Tsql Stmt

I have the following Tsql statement , however, since it has a single quote in it, it wont work. How do I go about replacing like what I have below.

update dbo.TABLE
set TITLE = 'E'
where TITLE = 'BA'S OFFICE'

Thanks
Tech315Asked:
Who is Participating?
 
AnujConnect With a Mentor SQL Server DBACommented:
update dbo.TABLE
set TITLE = 'E'
where TITLE = 'BA''S OFFICE'

Open in new window

0
 
Tech315Author Commented:
Thanks :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.