How to remove the last digit after the some symbols in SQL?

Question

For input

A.B.1.23

I want output

A.B.1

Is this u r looking for DECLARE @ AS VARCHAR(100) = 'A.B.1.23' SELECT REVERSE(SUBSTRING(REVERSE(@),CHARINDEX('.',REVERSE(@),0)+1,LEN(REVERSE(@)))) — Pawan Kumar, Feb 22 '18 at 12:20

score 1 · Accepted Answer · answered Feb 22 '18 at 12:20

1

In SQL Server, you can use:

select left(col, len(col) - charindex('.', reverse(col)))

This is dynamic and simply assumes that there is at least on '.' in the column.

answered Feb 22 '18 at 12:20

Gordon Linoff

score 1 · Answer 2 · answered Feb 22 '18 at 12:22

1

See if this helps..

DECLARE @ AS VARCHAR(100) = 'A.B.1.23'
SELECT REVERSE(SUBSTRING(REVERSE(@),CHARINDEX('.',REVERSE(@),0)+1,LEN(REVERSE(@))))

answered Feb 22 '18 at 12:22

Pawan Kumar

score 0 · Answer 3 · answered Feb 22 '18 at 12:53

0

You can use this also :

DECLARE @ AS VARCHAR(100) = 'A.B.1.23'
select substring(@, 1, len(@) - charindex('.', reverse(@)))

answered Feb 22 '18 at 12:53

Md. Suman Kabir

3 Answers3