The problem is that when I tried to index it:
CREATE INDEX dummy
I got this error:
Msg 537, Level 16, State 3, Line 21
Invalid length parameter passed to the LEFT or SUBSTRING function.
And when I tried to select data from the table, the same error.
Click through to find the real query killer.