[dba-VB] Client question!

Hans-Christian Andersen ha at phulse.com
Thu Jun 10 04:35:02 CDT 2010


I wonder if this is something SQL Servers "NEAR" proximity search can handle
effectively?

http://support.microsoft.com/kb/888008



Hans-Christian
Software Developer, UK

-----------------------------------------------------------------
tel: +44 (0)782 894 5456
e-mail: hans.andersen at phulse.com
www: nokenode.com
-----------------------------------------------------------------
Unique Gifts, Collectables, Artwork
-----------------------------------------------------------------
Come one
Come all to
www.corinnajasmine.com
-----------------------------------------------------------------



On 9 June 2010 14:11, David McAfee <davidmcafee at gmail.com> wrote:

> You can create a function to strip out characters using the replace()
> function.
>
> You can also look at soundex if you are using a SQL BE:
>
> http://msdn.microsoft.com/en-us/library/aa259235(SQL.80).aspx
>
> Sent from my Droid phone.
>
> On Jun 9, 2010 5:50 AM, "Michael Maddison" <michael at ddisolutions.com.au>
> wrote:
>
> Actually pre-processing and plonking the result in another field would
> work very well for large tables.
> This sucker only has 5K names after 6-7 years so I don't think
> performance will be much of an issue.
>
> Cheers
>
> Michael M
>
>
> I'm thinking that you should preprocess to get the name standardized.
> Assuming that O Tool is not a...
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.829 / Virus Data...
>
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> ...
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>



More information about the dba-VB mailing list