Dharmendra (.Net)
Thursday, 18 December 2014
Split test using delimiter and find last text
declare @abc nvarchar(200)='TM/OP/12012'
SELECT RIGHT(@abc,CHARINDEX('/',REVERSE(@abc),0)-1)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment