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]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
