Home Forums SQL Server 7,2000 Performance Tuning Using PATINDEX VS. LIKE RE: Using PATINDEX VS. LIKE
Adam Machanic
SSCoach
Points: 15370
More actions
November 8, 2004 at 3:09 pm
#529374
FYI, I posted my own test results here, along with an invitation for someone to show me how to prove that PATINDEX will, indeed, outperform LIKE:
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/08/4993.aspx
--Adam Machanicwhoisactive