>Ben,
>
>May I ask why you're using STR() to index and not another function?
Hi George,
In my former job we used compound index with STR function. Would it mean, that we will have performance hit in our queries? :(
If it's not broken, fix it until it is.
My Blog 
