Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

single quote

I tried to update this and it does not like single quotes. What should I do?

 UPDATE    mytable SET  custname = 'ST VINCENTS school'
              WHERE     (custname LIKE '%ST VINCENT'S school%')
0
VBdotnet2005
Asked:
VBdotnet2005
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Use a double-quote in place of the single..
UPDATE    mytable 
SET  custname = 'ST VINCENTS school'
WHERE     (custname LIKE '%ST VINCENT''S school%')

Open in new window

0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

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