pcsoft.us.windevCopyright 2026, PC SOFT1 Jul 2016 21:35:00 Z30 Jun 2016 21:42:00 ZHi, is there a simple solution for this ? SELECT CUSTOMER.CustomerLName FROM CUSTOMER WHERE CUSTOMER.City IN ('Montpellier', 'Avignon', 'Marseille') Customer.city could be 'Montpellier' or 'Avignon;Marseille' (multiple selection in a table)30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58446/read.awp1 Jul 2016 21:35:00 ZMichael As you say you can split the user chosen city strings and load each value in an array. Loop through the array - fo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58446/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58446/read.awpSQL Problem (Multiple values for the "IN" statement)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58445/read.awp1 Jul 2016 15:29:00 ZHi Fabrice, thats true. I can define a query (not in the Query-Editor), but I hate that :-( 1. Split the User-choosen c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58445/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58445/read.awpSQL Problem (Multiple values for the "IN" statement)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58444/read.awp1 Jul 2016 15:17:00 ZHi again so you are trying to use a contain X AND contain Y AND contain Z, with an unknown number of X Y Z.... hmmmm On…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58444/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58444/read.awpSQL Problem (Multiple values for the "IN" statement)Sebastian Arnoldpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58437/read.awp1 Jul 2016 14:41:31 ZHow about this: [code:sql] select CustomerLName from customer where ( city like '%London%' or city like '%Berlin%' ) [/code…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58437/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58437/read.awpSQL Problem (Multiple values for the "IN" statement)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58435/read.awp1 Jul 2016 13:58:00 ZHi Try this: SELECT CustomerLName FROM CUSTOMER as a WHERE a.City IN ('Montpellier', 'Avignon', 'Marseille') or SEL…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58435/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58435/read.awpSQL Problem (Multiple values for the "IN" statement)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58434/read.awp1 Jul 2016 13:50:00 ZOk, I try to explain: My Database has a field with the following values: Berlin Paris London Paris;London Berlin;Pa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58434/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58434/read.awpSQL Problem (Multiple values for the "IN" statement)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58433/read.awp1 Jul 2016 13:43:00 ZHi Michael, I'm not sure I understand the problem... In the query editor, when adding the condition, just use the "is in t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58433/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58433/read.awpSQL Problem (Multiple values for the "IN" statement)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58422/read.awp1 Jul 2016 07:30:00 ZHi Curtis, I need something like a "many to many" SQL Statement. The user can choose one or many values. Until now I sp…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58422/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58422/read.awpSQL Problem (Multiple values for the "IN" statement)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58412/read.awp30 Jun 2016 22:55:00 ZI don't quite understand your question. If 'Montpellier' and 'Avignon;Marseille' are the 2 values to search then the following w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58412/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58410-sql-problem-multiple-values-for-quotinquot-statement-58412/read.awpSQL Problem (Multiple values for the "IN" statement)