Find First Character

[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.

[Kurt Knippel]

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]

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