Hi Chris,

Try it:

strRange = "15,16,17"
lcSel="select * from events where ev_primary in ("+strRange+") into cursor curTemp"
&lcSel.

MartinJ

>Thanks John for your reply - yes I have tried that (although slightly different as I did not put the single quotes around number) and it works when I select into a cursor but not in a view...
>ie.
>

>strRange = "15,16,17"
>select * from events where ev_primary in (&strRange) into cursor curTemp
>

>but when I try to pass strRange to a view I either just get the first record returned or an error
>Thanks again