I run some tests to challenge the notion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.