Restricting a find request
I am working with an Order table that has Order_Number as the main field for searching but also a sub number field as well. The order number is generally always a numeric value, i.e 19704 but occasionally the order number will have to be say 19704A.
When I do a search to list all orders with the order number of 19704A I also get all orders with the number 19704.
How do I set it so that I will only get the orders that relate to main order 19704A.
Any assistance would be appreciated