Newbie - Cant get this like query to work

[experience30]

I have several products on one column which are separated by commas e.g. product1,product2,product3

 

On the webpage the customer will select a single product so i need a LIKE statement for the product  in the following statement

 

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1) AND (Product =@Product)

 

I've tried

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1) AND LIKE '%(Product = @Product)%'

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1) AND LIKE ('%Product = @Product%')

 

and several other variations - could someone be kind enough to put me out of my missery!

 

[experience30]

I've tried

 

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1)  AND (Product like '%@Product%')

 

which it accepts

 

However when i compile my app - it says i have too many arguements and highlights the product queries in the app where it gets data by product