>>I'd be tempted to consider keeping the codes in a table and just using a subquery for the condition. It would be pretty flexible, wouldn't have the limitations of a string and the subset of codes could be parameterized in whatever way necessary and the cursor used for the subquery.
>>
>
>It was already a table and I converted values to string first. I may just go straight with the table. For now I decided to just check directly against the codes in my code below the select statement.
If you are already in a table you have IMO a better solution that works in vfp or sql by just using a subquery which would work just like the inlist but with more flexibility.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.