Problem with List Query (IN Keyword) using Parameter

[woogoob]

This query works

Select * from tblTest where in ('abc', 'xyz')

But for the following query:

PARAMETERS parTest Text ( 255 );
SELECT *
FROM tblTest
WHERE (((TBL_CustomerPricing.ITEM_NUMBER) In ([parTest])));

when I enter 'abc','xyz' in the parameter field,
i get no records back.

Please tell me what I'm doing wrong?

Thanks in Advance!

 

[woogoob]

I meant to say
Select * from tblTest where ITEM_NUMBER in ('abc', 'xyz')
This query works