Rajkumar R

Rajkumar R

  • 1.9k
  • 183
  • 200.4k

How to split from last dot in sql server

Oct 25 2014 4:58 AM
Hi,
 
The below are the values stored in DB.
2013.ack
2013.regres
2013.zip.ack
Here I need to trim the values before the last dot(.).
The output should be like below
2013.
2013.
2013.zip.
 

Answers (1)