[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • Last Modified:

SQL - Delete

I need to delete a file and this is what I am trying to do:

delete
from dbo.PARMSET
where PARMSET_ID = 'Kris's TS';

The problem is that this person put a single quote in the name of the report. How do I go about deleteing this entry?
0
dude02
Asked:
dude02
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
delete
from dbo.PARMSET
where PARMSET_ID = 'Kris''s TS';
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Change it to two single-quotes

delete from dbo.PARMSET where PARMSET_ID = 'Kris''s TS';
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now