SeedCode Support Forum

I have a database, where each individual has a unique number that is automatically assigned. When I do a "find" on #5, I also get #'s 51,52,53,etc. Is there a way to just find #5, or the exact number in the field?

Thanks.

D. Peterson

Sure. For one thing, if your field was defined to be of the type "number" instead of the type "text", then a simple find for 5 would only find 5, not 55. In a text field, which is what it sounds like you have, you can find just 5 by placing an equals sign in front of your find criteria, like this: =5

That will find 5 not 55, though it will also find "a 5 b", "5 people" or any other record where this is a 5 along with additional text. If you want to exclude these other matches use two equals signs like this: ==5

Hope that helps.