>>Does anyone know if you can index on a substring in SQL 2008?
>
>Not directly but you can create an index on a calculated column.
Thanks Sergey. I may go with that.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright 
