Search from a comma seperated field
Posted on 2006-07-19
How do I write a query that searches for results in a field that has several numbers seperated by commas.
My Access database has a field called comma_jobs that has values that look like this:
varjobs is a Request.form var that has comma seperated values like the example above. How do I write the following to search paymaker for these value. the values are ID's for the records in paymaker if that helps any.
WHERE userid = 'varjobs'