Use the IN clause, like so :-
sql= "SELECT * FROM tablename WHERE serialnum IN ('A301', 'A200',
'A100');"
Dan
________________________________
From: asif mehdi [mailto:[EMAIL PROTECTED]
Sent: 31 January 2005 09:59
To: [email protected]
Subject: [AspClassicAnyQuestionIsOk] sql query problem
Hi skima,Michael Brinkley
thanks for Prompt reply..
but i have not solve my problem
In serial no coulmn
some time fields are like this
A100,A101,A1002
A200
A301,A302,A303,A304
i want find out exact rows of serial no like this A301 or A200 OR A100
if i do like this
dim sql
sql= "SELECT * FROM tablename WHERE serialnum LIKE 'A100%' "
if i have another serial no like A100,A1000,A10000
RESULT MATCHES ALL THREE SERIAL NO ,WHAT I DO PLEASE ADVICE
REGARDS
ASIF
Yahoo! India Matrimony: Find your life partneronline.
[Non-text portions of this message have been removed]
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
