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