Using access you can differentiate between numbers and letters using - [Purchases].[Lot]) Not Like '*[a-z]*' - Using this syntax in Access one can get all the records that have numbers only. Using this you get numbers only and only 4 placings ([Purchases].[Lot]) Not Like '####'
Is there a way to do this in MySQL