AnsweredAssumed Answered

Find records which contain a period

Question asked by StylisticGambit on May 1, 2014
Latest reply on May 1, 2014 by StylisticGambit

Title

Find records which contain a period

Post

     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.

Outcomes