First Name Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on an app where I need to do a search for like and similar first
name matches. For example a search for John would bring back Jon, John,
Jonathan, etc.

Working with asp.net and sql server. Any help would be appreciated.

Thanks,
Kent
 
Without going into a lot of detail, you definitely will want to check
out the System.Text.RegularExpressions.Regex class. Also of interest
will be creating full-text indexes on SQL Server, and using some of the
special TSQL string-searching functions that get enabled on those (such
as CONTAINS).
 
I'm working on an app where I need to do a search for like and similar
first name matches. For example a search for John would bring back
Jon, John, Jonathan, etc.
Click to expand...


You could try a SOUNDEX search... not sure how accurate it is. SOUNDEX
returns results based on word sound similarity.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search Suggestions 2
Address book data lookup (maybe javascript) 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Comparing two columns 1
Search two columns in list for first and last name and return Id 4
Macro to complete Google search based on a cell? 0
Wildcard search in dataview 1
Querying multiple words 1

Back
Top