Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Apr 20, 1997

Phonetic Searches

Question:
How can I perform a phonetic search in SQL? I need to search a database of names, but exact matches won't work. Using phonetic matching, I could find a name registered as, for example, "Beeter" when searching on "Bester".

Answer:
The fastest solution for text-based searches, including phonetic searches, is to use an add-on product to your front-end application development system (the product you choose will depend on your application development system).

The best advice I can offer, short of purchasing a product designed for complex text searches, is to create your own function or external routine. Joe Celko's book "SQL for Smarties" includes a routine for performing phonetic matching (please see my Books page under Resources for more information about the book).

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date