I have a field in my table which contains a string that is made of of
a series of numbers, followed by an 'arrow' (->), followed by some
more numbers. It will look roughly like this :
Both the series of numbers before and after the arrow are variable
between 1 and 9 numbers.
I'm looking for a way to extract the numbers to be able to use them in
a view (so it can either be a statement or a function).
Looking around, I saw mention of functions like 'LEFT' and 'RIGHT' or
'SUBSTR', but I ...