Check out example codes for "reutrn string after character sql". It will help you in understanding the concepts better.

Code Example 1

select right(col, charindex('-', reverse(col)) - 1)

Learn ReactJs, React Native from akashmittal.com