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)
Posted by Unknown at 23:30
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (8)
    • ►  July (1)
    • ►  June (1)
    • ►  May (3)
    • ►  February (3)
  • ►  2015 (46)
    • ►  September (2)
    • ►  August (2)
    • ►  July (9)
    • ►  June (1)
    • ►  May (6)
    • ►  April (9)
    • ►  March (7)
    • ►  February (1)
    • ►  January (9)
  • ▼  2014 (51)
    • ▼  December (6)
      • How do I disable right click on my web page?
      • How to check date of last change in stored procedu...
      • Split test using delimiter and find last text
      • blink text using css html
      • difference between WCF Services and Web Services a...
      • Select xml using sql table
    • ►  November (7)
    • ►  September (2)
    • ►  August (6)
    • ►  July (5)
    • ►  June (5)
    • ►  May (4)
    • ►  April (14)
    • ►  March (2)
  • ►  2013 (1)
    • ►  February (1)

About Me

Unknown
View my complete profile
Watermark theme. Powered by Blogger.