Good suggestion Mark. That's the fastest and cleanest way.
You can also use a (gulp) LIKE 'AB%' clause but if you do, make sure you put
an INDEX on this field so that the model numbers will already be
alphabetically sorted.
Another way would be to use regular expressions.
--Doug
-----Original Message-----
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 12:07 PM
To: CF-Talk
Subject: RE: Please help-Search engine
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?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?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
