1 Reply Latest reply on May 1, 2014 10:12 AM by StylisticGambit

    Find records which contain a period



      Find records which contain a period


           I have two text fields in my database: NameFirst and NameMiddle.

           Some of my users have been putting in the middle initial into the NameFirst field instead of the NameMiddle field.  For example, NameFirst reads "John B." and NameMiddle is empty.

           How do I form a request in find mode to search for entries that contain a period?

           I tried "*." and "*.*", but neither works.  The former returns no results and the later only returns entries with two periods, e.g., "A.J."  I also tried to use a backslash as an escape to search for a period ("*\." and "*\.*"), but that doesn't work either.