mySQL 5+ has soundex built in. But I don't think that will help. Peg doesn't sound anything like Margaret, and many nicknames have only superficial resemblance to their full versions.
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Ashwin Mathew [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 12:52 AM To: CF-Talk Subject: RE: Peg = Margaret name matching code Mike, I think you're looking for a soundex (http://en.wikipedia.org/wiki/Soundex), which does a "sounds like" comparison. I know that Oracle and SQL Server support soundex in the database - that might be the easiest thing to do. http://msdn2.microsoft.com/en-us/library/ms187384.aspx http://www.techonthenet.com/oracle/functions/soundex.php Ashwin www.sanmathi.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
