Select a range of alphanumeric values
706366Jul 21 2010 — edited Jul 21 2010hi,
i have a column with values like this:
001A45
124323
V1234C
...
these values have a theoretical order.
numbers have higher priority than chars.
the ranking of the chars is like: A = 1, ... , Z = 26.
is there a possibility to select an alphanumerical range in oracle?
thanks a lot!