AnsweredAssumed Answered

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

Question asked by BryanN on Apr 24, 2013
Latest reply on Apr 24, 2013 by 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?

Outcomes