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-58600i.e.58600.
- I am trying to do substr(INFORMATICS&SYSTEMS-58600,-5)which returnsATICSwhich is substr of first part of stringINFORMATICSbut 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.
 
     
     
     
    