Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How To Split From Last Dot In Sql Server?

Manoj Bhatt 2146 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.

Ask by Manoj Bhatt

Updated 27 Oct 2014

1 Answers

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))

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.