[AccessD] A2k: "I","U" in a string?

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


More information about the AccessD mailing list