Knowledgebase: Syntax
[QODBC-ALL] How to add Additional quote (') in Insert statement using QODBC
Posted by Jack - QODBC Support on 05 August 2014 11:51 AM

How to add Additional quote (') in Insert statement using QODBC

Problem Description:

I have exported the customer list from QB, and Now I want to insert these using the insert query. But some of them fail because of the apostrophe (').
How to deal with special characters like this.

Solutions:

I want to inform you that you can get an additional quote for your query.
For Example, If you want to add a customer whose name contains extra quotes, then you can insert the name using the below query:
Insert into customer (name) values ('Larry's Custom Invoice ')
The above question will create a customer entry named Larry's Custom Invoice.        

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).