Is Charindex is faster than like?
Is Charindex is faster than like? Certainly you should go with CHARINDEX if it outperforms LIKE. Yes, our procedure was working fine with LIKE but performance was an issue. However, i replaced the logic with CHARINDEX and it has improved the performance considerably. What is Charindex? The CHARINDEX() function searches for a substring in a […]