mmm...
Are you sure you want to ignore *any* number of non-numeric groups?
If so, one way would be denormalization... storing a second copy of
the part number in the table. This second part number would
represent the part number in a format that could be readily searched:
Real Part # Search Part #
-------------- --------------
12AB3456 123456
1AB23456 123456
123AB456 123456
Another way would be to use T/SQL statements, if the db is MS-SQL 7.
I would tend to recommend the denormalization... at the cost of a few
bytes in each record you greatly simplify the search process.
The input search field can be manipulated with regexp to easily
eliminate the non-numerics.
This isn't an electronics parts db, by any chance, it it>
HTH
Dick
At 10:42 PM -0500 5/15/2000, Jonathan Karlen wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0056_01BFBEBE.CE241C80
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Greetings -
>
>I am developing a parts database for a client which is keyed by part =
>number. He wants to be able to search by first numeric sequence. So, =
>for example, a search for 123456 would return part numbers 12AB3456, =
>1AB23456, 123AB456 and so on. =20
>
>>From a SQL point of view what I'd imagine I need to generate is a string =
>like "1%2%3%4%5%6%" to allow for characters between each number.
>
>Does anyone have any suggestions of how I can generate this string based =
>on user input?
>
>Thanks.
>
>Jonathan Karlen
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.