T-SQL LIKE statements need help

Question

I would like to search in DB

input line "oxoşil"

• o → [o-ö]
• x → [x-ks]
• ş → [s-ş]
• ş → [ş-sh]

I need to look for all these fights. Required search criteria: [o-ö] [x-ks] [o-ö] [ş-s-sh] [i-ı] l

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

Answer 1

I would try to force the sort to accent-insensitive. Of course, choose the one that suits you, not the Latin / General

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

Answer 2

One effective way to do this is to use the CLR stored procedure:

. : TSQL Regular Expression Workbench