Re: How do I bind variables to dynamic SQL?

Um, Thomas, I think you may have missed the most important point in my original post:

	The string of comma-delimited integers MUST remain intact.  
	Parsing it, and creating a varying number of
	predicates would NOT solve the problem. 

Parsing the values and retrieiving them one at a time works fine... Been there, done that.......... BUT, in the actual program there are ACTUALLY TWO QUERIES...........

1. select *... WHERE ... IN (set...)
2. select *... WHERE ... NOT IN (set...)

Parsing the string into some unknown series of individual values then putting each in the select statement would seem not to work well when doing a "not in"....... Thus, the reason for the original statement "THE STRING OF COMMA-DELIMITED INTEGERS MUST REMAIN INTACT." I'll give the instr a shot. It may have such serious performance implications its not usable, but its worth a shot. Received on Thu Sep 02 1999 - 20:27:19 CDT