Sad Der
accessd666 at yahoo.com
Fri Oct 24 00:30:42 CDT 2003
Hi group, I'm building a lot of dynamicly created queries. I need to create about 15 queries with in IN() statement eg: SELECT ID FROM tblConnections WHERE ID = '7' AND Type IN ("I","U") Question: I have 11 diff combinations of IN() types. ("I","U") ("T","Y") ("A","S") ("D","S") ETC. ETC. What is the best way to define these? Is it possible to store it in a string? something like: strIN = ""I","U"" TIA sd __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com