Perform Find to return records that match criteria within a string of characters
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?