>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 ??

If LEFT(NAME,10) equals something, then NAME equals that too -- unless you are working with SET EXACT ON or SET ANSI ON.