I am creating a parameterized view for my grid where I am trying to get a city or cities to show up. I create a list of all applicable cities and then select the ones I want and put them into a property of the form ccities as "Calgary","Edmonton" and so on. The SQL is

SELECT *;
 FROM geo!homechk;
 WHERE ALLTRIM(Homechk.city) IN (?thisform.ccities);
 ORDER BY Homechk.city, Homechk.lastname, Homechk.firstname

Only those records matching the first City are selected. I have tried this in the View designer and get the same results. Typing in a list of the cities works fine but as soon as you specify a parameter - no matter how you type in the list when it asks - it only matches to the first city in the list. What am I missing. TIA