Home Forums SQL Server 2005 T-SQL (SS2K5) Which is more efficient? WHERE SUBSTRING = ...or... WHERE fldField LIKE 'x%' RE: Which is more efficient? WHERE SUBSTRING = ...or... WHERE fldField LIKE 'x%'
_watching
Mr or Mrs. 500
Points: 530
More actions
October 14, 2015 at 6:01 pm
#1833358
If you're interested in updated speed comparisons on how fast each is (well, on SQL 2014 anyway), this ➡ LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX article with benchmarks makes for a great read.