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.

I don't know for sure with SQL statements, but I do know that the script compiler requires multiple quotes to add just one. Try 2 or 3 single quotes where you would normally use one.