RSS

Tag Archives: substring using query

split last string in sqlserver

    username

emp/satya
md/sai
emp/develop/suresh
clerk/surya
comp/sam

select reverse(substring(reverse(username),0,charindex(‘/’,reverse(username)))) from tblemp

 
Leave a comment

Posted by on September 30, 2011 in SQL SERVER

 

Tags: