forum

Home / DeveloperSection / Forums / How To Split From Last Dot In Sql Server?

Ask Question

How To Split From Last Dot In Sql Server?

Manoj Bhatt 1737 27-Oct-2014
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.
mssql server c#  sql server 
Updated on 27-Oct-2014
Manoj Bhatt

Manoj Bhatt

Follow

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

27-Oct-2014
Hi,
Please try with below sample 
DECLARE @Expression NVARCHAR(100)
SET @Expression = 'abc.test.sd'
SELECT SUBSTRING(@Expression,1,LEN(@Expression)-(CHARINDEX('.',REVERSE(@Expression))-1))

Liked By