How To Split From Last Dot In Sql Server?

Question

Anonymous User · Answer

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

forum

How To Split From Last Dot In Sql Server?

Manoj Bhatt

Can you answer this question?

1 Answers

Liked By