used to allow a match on 2 values if the first x characters starting from the left are the same. This is not case sensitive. Example: SubStrLeft(3) makes "Samual" match "Sam".