Hi, The below are the values stored in DB.2013.ack2013.regres2013.zip.ackHere I need to trim the values before the last dot(.).The output should be like below2013.2013.2013.zip.
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))
Total Post:154
Points:1086MSSQL Server C# SQL Server
Ratings:
726 View(s)
Rate this:
The below are the values stored in DB.