[dba-VB] Client question!

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

You can also look at soundex if you are using a SQL BE:


Sent from my Droid phone.

On Jun 9, 2010 5:50 AM, "Michael Maddison" <michael at ddisolutions.com.au>

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.


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

More information about the dba-VB mailing list