Обсуждение: 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;