SQL Server query problem

[mattastic]

Hi Folks,

Can anyone tell me how I can get this query to work.

SELECT * FROM JL_av_items WHERE 'Lap,Proj,SPK ' = Abbreviation;

I want to display all where the abbreviation column equals the list item.

Thankyou

[NightShift58]

SELECT * FROM JL_av_items WHERE Abbreviation IN ('Lap','Proj','SPK')