Try to enter this value in a new record: 9364TRD
Searching for 9364 will work, searching for TRD will not find that record.
BTW: try to find with: *9364
I'm not sure I understand that. Entering text only will match anywhere withing the field, eg "D" matches on TRD9364, so why won't 9364?
OK Thanks - resolved it. As it is under control of a script I have amended the script to insert an "*" if there isn't one there, and it is noe doing what I wanted it to.