SQL Query (on access)

[Jeremy Pullicino]

HI, Can someone help me with following SQL? I have an array of about 200 string IDs in my program (C++). I need to delete these IDs from a database table. I would like to use the most efficent method of doing this. Any suggestions on the best SQL query? Thanks Jeremy Pullicino C++ Developer Homepage

[Guillermo Rivero]

If your id columns is numeric, try this... DELETE FROM [Table] WHERE [ID_Column] IN (1,2,3,...,n) If it's string... DELETE FROM [Table] WHERE [ID_Column] IN ('1','2','3',...,'n) Free your mind...

[Dr_X]

Use the In Clause to execute the query.

DELETE FROM [TableName]
WHERE ID IN (1,2,3,4,5,6,etc...200)

I know Sysbase 11 had a limit of 255 values in the In Clause. However, I do not think SQL Server or Access has that limitation. Michael