In Access - look at portion of string
I have a field that has a number somewhere in it. I want to know that number so my query can tell Access to do an action. If the number is 27 print 100 but if the number is 54 print 100. The field looks like this "variable number of characters 27 variable number of characters"
Can you tell me how to do this?
Thank you for your time.