Link to home
Start Free TrialLog in
Avatar of Tech315
Tech315

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Anuj
Anuj
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tech315
Tech315

ASKER

Thanks :)