Fwd: VB6, ADO returns EOF via ODBC but has records in PSQL

>I'm trying to find the set of records that are not in a comma delimited
>list using an SQL statement like:
>
>SELECT name FROM construction WHERE name NOT IN ('a1 ',
>'a2 ', '') ORDER BY name;

etc...

Try select RTRIM(name) ... where not in ('a1', 'a2') etc

VBS/ADO acts weird with trailing spaces. Maybe there are other solutions too?

- Johann