Hi Mark,

>You should only use TRIM in an index expression if you are concatenating 2 fields. Like Index on trim(FirstName) + LastName.

I wouldn't put a trim there either. Just leave it

lname + fname

You'd have to pad lname with spaces on a seek where the variable didn't come from a field.