1.11M Members

SQL Query For String Searching

 
0
 

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.

 
0
 

Read this thread for some more information.

 
0
 

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

 
0
 

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

 
0
 

Are you using MSSQL too ?

 
0
 

YES.

 
0
 

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

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: