Have you tried it this way?
strRange = "'17','66','89'"
SELECT * FROM youthbase!ygprojects WHERE Ygprojects.pj_primary IN (&strRange)
>Hi - is it possible to use a view to return records that match the primary keys in a list?
>I have a view with this SQL
>
>SELECT *;
> FROM youthbase!ygprojects;
> WHERE Ygprojects.pj_primary IN (?vRange)
>
>
>I have tried passing it...
>strRange = "17,66,89"
>vRange = &strRange
>vRange = evaluate(strRange)
>but neither work - sometimes I get an error and sometimes I just get the first record returned
>
>If I put the values directly in the view I get the 3 records back OK
>
>Any ideas greatly appreciated