This content has been marked as final. Show 4 replies
If numbers is a numeric field, your query should crash because of your quotes. If numbers is a char field, you still want to get rid of the quotes and use the ListQualify function.
The problem could also be with your list. Does it look like this:
or does it look like this: 1,2,3
Try WHERE instr(<<field name goes here>>, '<<value to search for>>') <> 0
my list looks like the second option 1,2,3
In that case, the first part of my previous post answers your question. The only thing I would add is, if you field is char, get rid of all the spaces in your list before you apply the list qualify function.