Rajkumar R

Rajkumar R

  • NA
  • 183
  • 215.7k

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)