T-SQL Operators LIKE need help
i would like to search in DB
开发者_运维百科input string is "oxoşil"
- o -> [o-ö]
- x -> [x-ks]
- ş -> [s-ş]
- ş -> [ş-sh]
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?
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
One efficient way to do this is use a CLR Stored Procedure:
Regular Expressions Make Pattern Matching And Data Extraction Easier
See also: TSQL Regular Expression Workbench
精彩评论