Search Problem

[Tim Goss]

Hi:

I'm running FileMaker 6.0 Unlimited. I have a pulldown menu when searching for user names in the database. When I search on the name "Noteboom S" it finds all the records for that user. When I search on "Noteboom N" it finds all the records for both "Noteboom S" and "Noteboom N". And now here's where it gets weird. I have two other users with the same last name ("Smith R" and "Smith T") and different first intitials, but their searchs work perfectly. And even weirder: If I change "Noteboom N" to "Noteboom L", it works. "Noteboom Na" works. . . just not "Noteboom N".

Any suggestions? Thanks in advance.

Tim