Find by last letters

[Brian_In_PA]

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?

[mz123]

Hey there!

You could create a calculation field:

Right( Name ; 2 )

Then you could search on that field.

Hope that helps!

[Brian_In_PA]

Thanks,

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

Looking for a way to find words that share common endings

[mz123]

Check out my attached file:

test.fp7_2.zip

[Ender]

Try a find with a wildcard, like this:

*th

[Brian_In_PA]

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