I know this type of questions have been asked before but none solves my problem.
- I want to capture numeric parts of this string
INFORMATICS&SYSTEMS-58600
i.e.58600
. - I am trying to do
substr(INFORMATICS&SYSTEMS-58600,-5)
which returnsATICS
which is substr of first part of stringINFORMATICS
but I want the last part. - Wherever & is appearing this is behaving same.
I know its a very basic mistake but what ??? I cant figure out.Please help me out.