2 Replies Latest reply on Apr 24, 2013 10:07 AM by BryanN

    Perform Find to return records that match criteria within a string of characters

    BryanN

      Title

      Perform Find to return records that match criteria within a string of characters

      Post

           I am sure there is a way to do this but my search has come up empty.  I'm trying to perform a find that will match two characters next to each other within a string of characters.  Example:

            

           Our quotes have a format of REQMMDDYYIINN  ( II = first two letters from the username and NN = quote serial #)

            

           So if a quote has REQMMDDYYBNNN, I'm trying to search within this field to return only ones that have "BN" or "JB" in the middle.  How can I do this?