David McAfee
davidmcafee at gmail.com
Wed Jun 9 08:11:39 CDT 2010
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 ...