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