Partial Words search

[Darren Heinrich]

Hi - can anyone point me to info on how to search on partial words using ASP
?
For instance if a db field contains the product name 'cx-3', but the user
enters 'cx3'.
Or if a field contains 'synthesizer' and the user enters 'synthesiser'.

Thanks

Darren

[Mark Schupp]

You probably want a "soundex" search. What DBMS are you using?

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
news:uRWTb.18$%A5.1402@nnrp1.ozemail.com.au...

> Hi - can anyone point me to info on how to search on partial words using

ASP

> ?
> For instance if a db field contains the product name 'cx-3', but the user
> enters 'cx3'.
> Or if a field contains 'synthesizer' and the user enters 'synthesiser'.
>
> Thanks
>
> Darren
>
>

[Darren Heinrich]

I'm using Access unfortunately. Is that what you mean by DBMS ?

Darren

"Mark Schupp" <mschupp@ielearning.com> wrote in message
news:uvZEiVr6DHA.2432@TK2MSFTNGP10.phx.gbl...

> You probably want a "soundex" search. What DBMS are you using?
>
> --
> Mark Schupp
> Head of Development
> Integrity eLearning
> [url]www.ielearning.com[/url]
>
>
> "Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
> news:uRWTb.18$%A5.1402@nnrp1.ozemail.com.au...

> > Hi - can anyone point me to info on how to search on partial words using

> ASP

> > ?
> > For instance if a db field contains the product name 'cx-3', but the

user

> > enters 'cx3'.
> > Or if a field contains 'synthesizer' and the user enters 'synthesiser'.
> >
> > Thanks
> >
> > Darren
> >
> >

>
>

[Chris Hohmann]

"Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
news:E9XTb.25$%A5.1582@nnrp1.ozemail.com.au...

> "Mark Schupp" <mschupp@ielearning.com> wrote in message
> news:uvZEiVr6DHA.2432@TK2MSFTNGP10.phx.gbl...

> > "Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
> > news:uRWTb.18$%A5.1402@nnrp1.ozemail.com.au...

> > > Hi - can anyone point me to info on how to search on partial words

using

> > ASP

> > > ?
> > > For instance if a db field contains the product name 'cx-3', but

the

> user

> > > enters 'cx3'.
> > > Or if a field contains 'synthesizer' and the user enters

'synthesiser'.

> > >
> > > Thanks
> > >
> > > Darren
> > >
> > >

> > You probably want a "soundex" search. What DBMS are you using?
> >
> > --
> > Mark Schupp
> > Head of Development
> > Integrity eLearning
> > [url]www.ielearning.com[/url]
> >
> >

> I'm using Access unfortunately. Is that what you mean by DBMS ?
>
> Darren

Here's something Google came up with:
[url]http://groups.google.com/groups?selm=20020110121725.06317.00000155%40mb-fp.aol.com[/url]

As this relates to ASP, you'll want to investigate the "ASP Soundex
function" link.

You might also consider either migrating to a more robust database with
native SOUNDEX support or (and this seems like overkill) deploy MS
SQLServer/Oracle and created links to your MS Access database solely for
the purpose of using the SOUNDEX function.

Note: The quoted material in this reply was reordered to preserve
continuity of flow. Please consider posting responses/replies below
quoted text.

HTH
-Chris Hohmann

[Darren Heinrich]

Thanks Chris - I think I'll have to give that a miss, as it sounds over my
head and over my clients budget.

Thanks anyway

Darren


"Chris Hohmann" <nospam@thankyou.com> wrote in message
news:%23KKYZas6DHA.2496@TK2MSFTNGP09.phx.gbl...

> "Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
> news:E9XTb.25$%A5.1582@nnrp1.ozemail.com.au...

> > "Mark Schupp" <mschupp@ielearning.com> wrote in message
> > news:uvZEiVr6DHA.2432@TK2MSFTNGP10.phx.gbl...

> > > "Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
> > > news:uRWTb.18$%A5.1402@nnrp1.ozemail.com.au...
> > > > Hi - can anyone point me to info on how to search on partial words

> using

> > > ASP
> > > > ?
> > > > For instance if a db field contains the product name 'cx-3', but

> the

> > user

> > > > enters 'cx3'.
> > > > Or if a field contains 'synthesizer' and the user enters

> 'synthesiser'.

> > > >
> > > > Thanks
> > > >
> > > > Darren
> > > >
> > > >
> > > You probably want a "soundex" search. What DBMS are you using?
> > >
> > > --
> > > Mark Schupp
> > > Head of Development
> > > Integrity eLearning
> > > [url]www.ielearning.com[/url]
> > >
> > >

> > I'm using Access unfortunately. Is that what you mean by DBMS ?
> >
> > Darren

>
> Here's something Google came up with:
>

[url]http://groups.google.com/groups?selm=20020110121725.06317.00000155%40mb-fp.aol.com[/url]

>
> As this relates to ASP, you'll want to investigate the "ASP Soundex
> function" link.
>
> You might also consider either migrating to a more robust database with
> native SOUNDEX support or (and this seems like overkill) deploy MS
> SQLServer/Oracle and created links to your MS Access database solely for
> the purpose of using the SOUNDEX function.
>
> Note: The quoted material in this reply was reordered to preserve
> continuity of flow. Please consider posting responses/replies below
> quoted text.
>
> HTH
> -Chris Hohmann
>
>
>