How to split string in sql server query

How to split string in sql server queryQuestion : If I have strings like 'abc/123' then  split string function to obtain only 123 from the string.

Answer:

RTRIM(RIGHT(Field1, LEN(Field1) - CHARINDEX('/',  Field1)))

Comments