Jump to content

Using Single Quotes in Execute SQL script step


This topic is 7812 days old. Please don't post here. Open a new topic instead.

Recommended Posts

The answer is probably painfully obvious, but if's Friday and my brain is locked.

When forming the SQL query in a Execute SQL script step, how do I use a combination of single quotes and an apostrophe?

Here's the Query in question : UPDATE tDesigns SET fDescription = 'Hank's Truck' WHERE fDesignId = '495'

Here's the script step: "UPDATE tDesigns SET fDescription = '" & Design Description & "' WHERE fDesignId = '" & DesignID & "'"

It's generating an error (understandably) when it hit's the apostrophe in Hank's.

Any help is much appreciated.

Link to comment
Share on other sites

This topic is 7812 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.