Reputation: 21

T-SQL Operators LIKE need help

i would like to search in DB

input string is "oxoşil"

i need to search all of these cominations. Needed finally search criteria is [o-ö][x-ks][o-ö][ş-s-sh][i-ı]l

is there any way to to this with t-sql like operator? or in linq?

Upvotes: 2

Answers (2)

Reputation: 432481

I would try coercing the collation to accent-insensitive.Of course, choose an appropriate one for you rather than latin/general

WHERE
    myCol COLLATE LATIN1_GENERAL_CI_AI LIKE '%oxoşil%' COLLATE LATIN1_GENERAL_CI_AI

Upvotes: 3

Reputation: 300718

One efficient way to do this is use a CLR Stored Procedure:

Upvotes: 0