SQLSERVER截取字符串 

 1 DECLARE @Name NVARCHAR (50)  
 2 SET @Name = '\EXAM\061023478874'  
 3       
 4 DECLARE @Position INT  
 5       
 6 --sql first indexof  
 7 SET @Position = CHARINDEX('.', @Name);  
 8 SELECT SUBSTRING (@Name, @Position+1,LEN(@Name)-@Position)  
 9       
10 --sql last indexof  
11 SET @Position =  LEN(@Name) - CHARINDEX('\', REVERSE(@Name)) + 1  
12 SELECT SUBSTRING (@Name, @Position+1,LEN(@Name)-@Position)

 

posted @ 2015-12-03 10:48  Thinking.N  阅读(696)  评论(0)  编辑  收藏  举报