Select of multipel data from database

[Claus G]

Hello

I have this codeline:

Set rs = Conn.Execute("SELECT * FROM nyhedsbrev Where postnummer = 7430
")
Where the postcode 7430 is selected, but y nead to draw many ´specifik
numbers at the same time, as well as exclude others. Can anybody help?
Best regard.

[Mark Rae]

"Claus G" <cl******@jubii.dkwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...

Set rs = Conn.Execute("SELECT * FROM nyhedsbrev Where postnummer = 7430")

Where the postcode 7430 is selected, but y nead to draw many ´specifik
numbers at the same time, as well as exclude others. Can anybody help?

SELECT *
FROM nyhedsbrew
WHERE postrunner IN (7430,7431,7432)
AND postrunner NOT IN (7433,7434,7435)

[Claus G]

Mark Rae skrev:

"Claus G" <cl******@jubii.dkwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...

Set rs = Conn.Execute("SELECT * FROM nyhedsbrev Where postnummer = 7430")

Where the postcode 7430 is selected, but y nead to draw many ´specifik
numbers at the same time, as well as exclude others. Can anybody help?

SELECT *
FROM nyhedsbrew
WHERE postrunner IN (7430,7431,7432)
AND postrunner NOT IN (7433,7434,7435)

Thank You it works, everything is so easy whwn you now have to do it. i
am very greatfull.
Claus G

[Mark Rae]

"Claus G" <cl******@jubii.dkwrote in message
news:11**********************@m7g2000cwm.googlegro ups.com...

Thank You it works, everything is so easy whwn you now have to do it. i
am very greatfull.

No problem.

Don't take this the wrong way, but the T-SQL I gave you is *really* basic,
so you might benefit hugely from a beginner's guide...

Everybody has to start somewhere, and this sort of thing can be really
daunting without the basic building blocks...

Also, if you are building up SQL dynamically, you can run into problems with
SQL injection (Google it), so you should at least investigate using a stored
procedure / parameterised query if you can...