Syntax error(missing operator) in query expression "siff's');'.

[tosifmemon2000]

Hello Friends,



I have created a one table named "Contacts" with two fields as Fname,Lname with text data type. whenever i tried to insert name as "Macdonald's" in a Fname field using insert query as "insert into Contacts(fname) values('Macdonald's'); then it throws error as "Syntax error(missing operator) in query expression "siff's');'.".


Please help me to solve dis issue...

Thanks in advance..

--Tausif

[alansidman]

Your issue is that the name Macdonald's has an apostrophe in it. Here is how to get around that issues.

http://p2p.wrox.com/sql-language/447...postrophe.html