Stored query using array as parameter

Question

I have the following stored query in an MS Access DB:

PARAMETERS pNumber Long;
SELECT *
FROM entries
WHERE id IN ([pNumber]);

Is it possible to do something like:

PARAMETERS pNumberArray Long Array;
SELECT *
FROM entries
WHERE id IN ([pNumberArray]); // pNumberArray = 33, 51, 84, 100

The array will be provided by VB6

Fionnuala · Accepted Answer · 2013-02-01 11:11:35Z

1

You need a slightly different approach:

SELECT *
FROM entries
WHERE InStr([pNumberArray],[ID])>0

answered Feb 1, 2013 at 11:11

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1