>Does anyone know if you can index on a substring in SQL 2008?
No. Also, are you talking about Full Text indexing or just indexing? In any case, you can only index on columns in SQL Server (but you can create persisted computed column with your function)
See also
Function based index in T-SQL
If it's not broken, fix it until it is.
My Blog