Please let other users know how useful this tip is by rating it below. Do you have a tip or code of your own you'd like to share? Submit it here.
When you execute insert queries with ' charecter as part of the text portion, it will give you an error. To get around this problem, you can use replace function to convert this single ' to a set of ''.
variablename = replace(replace(variablename,"'","''"),chr(13),""""))