Hi, I have a column of postal codes that are a string, not integers, so metabase does not give me the option to do a "Between" operation. I am trying to separate postal codes that are between 90000 and 93000 from postal codes between 94000 and 96000. When I go to filter, I only have the options: IS, IS NOT, IS EMPTY, and NOT EMPTY.
I also tried to use the mapping function but that is not operational with this data. I am not sure if that is also because the postal codes are a string.
Advice on both of these would be much appreciated.