I've got a fairly unique situation where i need to filter out records based on a location code. I have two regions in a warehouse, Quickpick and then Stock.
The Quickpick locations have a code of a letter followed by 3 numbers (A001, B203). The Stock locations are 2 letters and a number (FJ4, CA1).
I need to be able to filter out the locations that are 2 letters and a number, returning only items that would be from the first area, Quickpick, that has Letter and 3 numbers.
So.....
anyone know how i should write this?
Thanks in advance.
The Quickpick locations have a code of a letter followed by 3 numbers (A001, B203). The Stock locations are 2 letters and a number (FJ4, CA1).
I need to be able to filter out the locations that are 2 letters and a number, returning only items that would be from the first area, Quickpick, that has Letter and 3 numbers.
So.....
anyone know how i should write this?
Thanks in advance.