The best way to do it is to include a "%" in the sql query
example:
dim sql
sql= "SELECT * FROM tablename WHERE serialnum LIKE 'A100%' "
The "LIKE" in the query is a part of sql reserve word that tells the
query to search for where the data in the DB matches the requested
one.
Hope this help.
...skima
On Sat, 29 Jan 2005 11:35:09 +0000 (GMT), asif mehdi
<[EMAIL PROTECTED]> wrote:
>
> I have problem in SQL query...
> I have one Table having serial no field.in the Serial number fields data are
> stored with seprated by qumo like A100,A1002,A1003......
> I want to write a query to match one Serial no Like A100
> How to write query.
> please Any one Advice...
> regards
> asif
>
> Yahoo! India Matrimony: Find your life partneronline.
>
> [Non-text portions of this message have been removed]
>
> Yahoo! Groups Links
>
>
>
>
>
--
www.skimawebsolution.com simply websolution.
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/
