Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Find First Character

June 3, 200025 yr

Newbies

Is there a way to create a find that will find any record by the first letter of the field? Example: I need to find all records beginning with the letter "A" in a certain field.

June 3, 200025 yr

quote:

Originally posted by Rich Young:

Is there a way to create a find that will find any record by the first letter of the field? Example: I need to find all records beginning with the letter "A" in a certain field.

You could start with a find that uses "A*" to find anything that begins with A. However this may not work exactly as you want so as a second idea you might setup a calc which is Left ( fieldname, 1 ) to get the first character ONLY of the field, then do a find on that field. That calc can be stored so the find should be pretty quick.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=