I would split up the alpha numeric model number into two fields - a prefix field for
the alpha characters and a suffix field for the numeric characters..
Then I'd do a LIKE search on the alpha characters and an exact search on the numbers...
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: monika kon [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 11:38 AM
> To: CF-Talk
> Subject: Please help-Search engine
>
>
>
>
> Hello Everyone.
> Please help me I am stuck.
> I have to make a search on the basis of model number
> which is present in Access database.
> If I write model number suppose"ABC1111" or "AB1111"
> then it should show me the same result.
> That means while searching the alphabets should be
> truncated automatically.
> Please tell me how to do this.
>
> Please help!!!
>
> Thanks in advance.
>
> Shally
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
