Knowledgebase: Functions
[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 customer list from QB and Now I wanted to insert these using insert query. But some of them are failing because of having the apostrophe (').
How to deal with special characters like this.

Solutions:

I would like to inform you that you can additional quote in your query.
For Example, If you want to add customer whose name contains extra quotes, then you can insert name using below query:
Insert into customer (name) values ('Larry''s Custom Invoice ')
The above query will create customer entry with name 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).