MID function only working for letters not numbers

Trying to do a very straightforward check of an alphanumerical code being returned correctly in a dataset by using the MID function for each variable in the code, and for some reason it’s only returning “true” / “finding” the digits with MID where the subject digit is a letter. Numbers result in a “false” / not found when doing =IF(MID formula)=character reference,True,False)

For example, searching for 2 in the first character of “2NOPE7” will result in a failed/not found, whereas searching for N in the second character will result in a success/found.