>Hi,
>
>We have an index on the field 'Name'. If we are using LEFT(Name,10) when performing a search, is it faster if we create an index on this expression or can the search use the index on Name ??
With set exact off (default), you could use just :
name = LEFT(Name,10)
Cetin