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 > >