First Name Search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

k dog - 23 Jan 2006 15:30 GMT

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

Reply to this Message

KJ - 23 Jan 2006 15:46 GMT

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

Reply to this Message

Mark Newmister - 23 Jan 2006 16:01 GMT

http://www.wwwcoder.com/main/parentid/191/site/2189/68/default.aspx

> I'm working on an app where I need to do a search for like and similar
> first
[quoted text clipped - 5 lines]
> Thanks,
> Kent

Reply to this Message

Spam Catcher - 23 Jan 2006 17:10 GMT

> 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.

You could try a SOUNDEX search... not sure how accurate it is. SOUNDEX
returns results based on word sound similarity.

Signature

Stan Kee (spamhoneypot@rogers.com)

Reply to this Message

First Name Search

Free Magazines