Stripping a string in SQL Server

Question

I need to strip and display strings of column in SQL Server. The strings are like this

Actual String      I want to display in select statement
DCB1000-1             DCB1000
DCB-100-2             DCB-100
DCB-300-2             DCB-300

Marco · Accepted Answer · 2011-09-06 06:30:15Z

1

Try this:

SELECT SUBSTRING(your_field, 1, 7)
FROM your_table

EDITED:
Well, try this:

SELECT SUBSTRING(your_field, 1, 
    LEN(your_field) - CHARINDEX('-', REVERSE(your_field)))

The idea is to find last "-" char (so first one in reversed string) and get substring from the beginning to there...

answered Sep 6, 2011 at 6:25

Marco

57.7k15 gold badges135 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nagendra U M · Accepted Answer · 2011-09-06 06:25:05Z

0

Regards,
Nagendra U M

answered Sep 6, 2011 at 6:25

Nagendra U M

6212 gold badges7 silver badges16 bronze badges