Find problem

General support questions.
Posts: 6
Joined: Sat May 07, 2005 7:21 am
PostPosted: Sat Jun 04, 2005 8:23 pm
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
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Sun Jun 05, 2005 7:38 am
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.
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron
(855) SEEDCODE
[email protected]
Follow us: