The harib- there are many different ways to do this:

find the total length of string using LEN() function... then

find the position of the first occurance of '/' from backward using STRSTR() -- string search function.

then use SUBSTR() function from last position to the position where that '/' is.

By the way, wha is the system? Oracle or SQL server?