We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!

1,075,839 Members — Technology Publication meets Social Media

Start New Discussion Reply to this Discussion

Ad: Free Investment Planning kit

0

SQL Query For String Searching

My case is
Input is "abdknmgbm".
BUT
The record in database that i want to query out is "abkdnmgmb"
The input and database record is quite similar.
String length is same, only some arrangement of character are not same.
In the above case, dk and kd ; bm and mb.
How i write query for this string searching?
Help and Thanks.

2

Contributors

6

Replies

22 Hours

Discussion Span

4 Months Ago

Last Updated

7

Views

Newbie Poster

18 posts since Mar 2012

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

0

Read this thread for some more information.

Posting Prodigy

Moderator

9,267 posts since Jul 2006

Reputation Points: 1,173

Solved Threads: 1,456

Skill Endorsements: 86

0

Tq... But i am using asp.net with c#.

Newbie Poster

18 posts since Mar 2012

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

0

In addition, i cannot use SOUNDEX. Because my record is not the english vocabulary.

Newbie Poster

18 posts since Mar 2012

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

0

Are you using MSSQL too ?

Posting Prodigy

Moderator

9,267 posts since Jul 2006

Reputation Points: 1,173

Solved Threads: 1,456

Skill Endorsements: 86

0

YES.

Newbie Poster

18 posts since Mar 2012

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

0

Have a look at the full-text search capabilities of MS SQL Server.

Posting Prodigy

Moderator

9,267 posts since Jul 2006

Reputation Points: 1,173

Solved Threads: 1,456

Skill Endorsements: 86

This article has been dead for over three months: Start a new discussion instead

You

Web Development > Databases

© 2013 DaniWeb® LLC

Page rendered in 0.0717 seconds using 2.66MB