Member Avatar for lhsunshine

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
  • 121 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Read this thread for some more information.

Member Avatar for lhsunshine

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

Member Avatar for lhsunshine

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

Member Avatar for pritaeas

Are you using MSSQL too ?

Member Avatar for pritaeas

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.