!!! both of you win. this simplifies a horrible while loop. I hate while loops. everything should be relationally retreivable and happy, and now I am. :-D Thanks again.
Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ramsour Mike Sent: Thursday, March 13, 2008 4:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: more crazy ideas of mine Jeff: You might try reversing the approach. I learned trick this years ago and it comes in handy. select requirements from reqlist where .vwhat contains ctxt(reqid) Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340 -----Original Message----- From: Jeffrey M. Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 5:36 PM To: [email protected] Subject: [RBASE-L] - more crazy ideas of mine I am trying to find a way to get a select working on a comma separated list so I don't have to throw it in a while-loop and parse it. I was trying the following (which means it is inherently incorrect) say my field name Is IDLIST and It contains the values '1025,1098,2048,3152' set var vwhat = '1025,1098,2048,3152' select requirements from reqlist where ctxt(reqid) in (.vwhat) where reqid is an integer column in reqlist... is there some way to manipulate it like this? Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700
