Can I do this???

[PhatH]

This is my current code:
sql = "SELECT * FROM tblProductType WHERE ProdTypeID IN (SELECT DISTINCT ProdTypeID FROM tblProducts WHERE ManuID = '" & request.querystring("ManuID") & "')"

that was then when the ProdTypeID was a int and had only 1 number. Now, I changed the value into varchar where it will contain a collected data from checkboxes such as, 1, 2, 3, ...

Question:
Can I somehow break the ProdTypeID string in the tblProducts into each individual number and compare the numbers to get data from tblProductType?

P.S. The idea is I want to get Name(s) from tblProductType where each broken down tblProducts.ProdTypeID = tblProductType.ProdTypeID

 

[ToddWW]

sql = "SELECT tblProductType.* " _
 & "FROM tblProductType " _
 & "INNER JOIN tblProducts " _
 & "ON tblProductType.ProdTypeID = tblProducts.ProdTypeID " _
 & "WHERE TableName.ManuID = '" & request.querystring("ManuID") & "'"