Brian:
You probably want o be using wildcard matching instead of the IN operator.
Your query should be changed to something like:
WHERE (
Emonth LIKE '%,#frmEMonth#,%'
OR Emonth LIKE '#frmEMonth#,%'
OR Emonth LIKE '%
Thank you Mosh. Your code works perfectly.
I thought there might be a way to convert column data
from a string into a comma-separated list using
whatever token you needed. So if a column row
contained "1,2,3" (1 element) it would be converted to
"1","2","3" (3 seperate elements). It was just a
th
2 matches
Mail list logo