DECLARE @Name NVARCHAR (50)

 SET @Name = '\EXAM\061023478874'  

 DECLARE @Position INT  

 --sql first indexof

 SET @Position = CHARINDEX('.', @Name);

 SELECT SUBSTRING (@Name, @Position+1,LEN(@Name)-@Position)  

 --sql last indexof

 SET @Position =  LEN(@Name) - CHARINDEX('\', REVERSE(@Name)) + 1

 SELECT SUBSTRING (@Name, @Position+1,LEN(@Name)-@Position)