I'm trying to select from a comma delimited field in an access database. The problem I have is using "like" gives me all the results that contain a 1 like 1, 11, 21, etc. How do I switch the query to only pull the results that actually equal 1 from within the comma delimted array? <%strSQL="SELECT * FROM products where category like '%1%' " Set rst = CreateObject("ADODB.Recordset") rst.Open strSQL, con, adOpenStatic, adLockReadOnly, adcmdText%> Code (markup): thanks