Fox can only create fixed length indeces. Doing a TRIM doesn't save anything...and in fact will slow things down. You can do the trim on the right side of the comparison.

>Cetin -
>N and st_name are both fields in the current table. The locate is followed by an if found() and replace statement. What I'm doing is populating a street name field based on the node numbers of a grid. There are actually 3 of these locate statements in the loop. The current table is just 2 fields containing a list of points (nodes) and the streets that intersect at that point. What I'm doing here is populating crsTemp with the names of the streets that intersect the endpoints of a roadway. I'm hesitant to drop the trim for fear I won't find the match or I'll find the wrong match because "Bourbon" is really not the same street as "Bourbon St."
>
>Thanks