Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IN operator

Status
Not open for further replies.

varocho

Programmer
Dec 4, 2000
238
US
I'm using System 11 and would like to know how can I use a comma-delimited list of values passed to a stored procedure with the IN operator (besides creating and using a temp table)?
 
you can't.

on system 12, you can dynamically execute a string like this

select @s = "1,2,3,4"
exec("select * from foo where id in (" + @s + ")")

but on 11 you're out of luck. Carnage Blender. Over 40 million battles served.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top