One way to get an index seek for a leading %wildcard In an effort to make leading wildcard searches sargable, Aaron Bertrand (@AaronBertrand) plays around with a trigram-type implementation in SQL Server. Aaron Bertrand ◆ February 3, 2017 32
Pattern Matching : More Fun When I Was a Kid Aaron Bertrand (@AaronBertrand) runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE. Aaron Bertrand ◆ September 6, 2016 10