Include the comma: 'A100,%' Or you'll get the A1003,A1004 etc. too.
--- sheriff shittu skima <[EMAIL PROTECTED]> wrote: > 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. > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 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/
