You have to declare a computed column in the table and then index it.

-Mike

>In my vfp I have a lot of indices on partial fields, e.g. 'index on left(field_2,9)'. When I try this in SQL Server 2000 I get syntax errors. How can I get the equivalent of my vfp indices in SQLServer2000?