Hi,
im not sure whether this is a basic kind of problem but I would like you to make any suggestions how you would solve this thing.
There are all different regions(in a country). I have all the rules how to figure out a REGION out of a postal code(always 4-digit). This is an example(VBG and STM are two different regions)
VBG:
----
67.. - 69..
STM
----
7421
80.. - 803.
830. - 836.
84.. - 89..
9323
Could anyone suggest a SQL Query when I want to list all entries of a region? I think it should work somehow with LIKE but I dont know how to code those dots(.) Each stands for a number(0-9). Thank you a lot!
im not sure whether this is a basic kind of problem but I would like you to make any suggestions how you would solve this thing.
There are all different regions(in a country). I have all the rules how to figure out a REGION out of a postal code(always 4-digit). This is an example(VBG and STM are two different regions)
VBG:
----
67.. - 69..
STM
----
7421
80.. - 803.
830. - 836.
84.. - 89..
9323
Could anyone suggest a SQL Query when I want to list all entries of a region? I think it should work somehow with LIKE but I dont know how to code those dots(.) Each stands for a number(0-9). Thank you a lot!