Barry, You might want to create a new field, say "ID", and update it using "Table > Update column" with the value
mid$(oldfield,12,2) & left$(oldfield,8) & right$(oldfield,len(oldfield)-14) ...assuming that the field containing the lot and plan number is called "oldfield" and of type character(). You might want to modify the last part (right(oldfield...) to your needs. The new field ID could the be used for geocoding etc. Best regards Daniel
