1
Answer

How to split from last dot in sql server

Rajkumar R

Rajkumar R

10y
757
1
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)