I would like to find records where the last letters of a name are the search criteria.

For example:

by searching on "th" the returned set would contain both Smith and Forsyth but not Thomas

searching on "ez" would return perez and martinez but not ezra

Any ideas?

Hey there!

You could create a calculation field:

Right( Name ; 2 )

Then you could search on that field.

Hope that helps!

Thanks,

Tried that and it returns words that start with those two letters...

Looking for a way to find words that share common endings

Check out my attached file:

test.fp7_2.zip

Try a find with a wildcard, like this:

*th

Thanks,

used this field calculation as an extension of your suggestion

Right ( Last_Name ; Length ( FindSpecial_Field ) )

where FindSpecial_Field contains the ending that I want to search on

Then I seach on the contents of the calculated field