Give output if between postcodes
Posted: Fri Nov 12, 2010 11:13 am
Hi,
Im struggeling with a query:
I want to have a IF BETWEEN statement between two fields: postcode_min and postcode_max
But as you might know, not all postcodes in the world are just numeric...
So: How can I get a IF BETWEEN statement when the fields might be something like this: postcode_min = E3 2AA and postcode_max = E3 2BB (UK postcodes)
Im struggeling with a query:
I want to have a IF BETWEEN statement between two fields: postcode_min and postcode_max
But as you might know, not all postcodes in the world are just numeric...
So: How can I get a IF BETWEEN statement when the fields might be something like this: postcode_min = E3 2AA and postcode_max = E3 2BB (UK postcodes)