pcsoft.us.windevCopyright 2026, PC SOFT24 Sep 2015 11:35:00 Z24 Sep 2015 00:52:00 ZI have a line of code: FOR EACH gpsdContact WHERE "sFirstName ~= ' "+EDT_FirstName+" ' AND sLastName ~= ' "+EDT_LastName+" ' " Thank won't work if the name has an apostrophe in it like O'Brien. How do I fix this?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54115/read.awp24 Sep 2015 11:35:00 ZHi Paulo, The escaping example you refer to concerns WLanguage filtering. I thought Joel is using SQL but was too fast. I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54115/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54115/read.awpProblem with apostropheguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54110/read.awp24 Sep 2015 10:32:00 Zyou must escape the apostrophe with a backslash, check this help page in the section Filter (syntaxes 2) http://doc.windev.co…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54110/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54110/read.awpProblem with apostropheguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54108/read.awp24 Sep 2015 09:13:00 ZHey Joel, FOR EACH gpsdContact WHERE "sFirstName ~= ' "+Replace(EDT_FirstName,"'","''")+" ' AND sLastName ~= ' "+Replace(EDT_…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54108/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54107-problem-with-apostrophe-54108/read.awpProblem with apostrophe