sql - getting text between parentheses

Question

I have text like this:

San Demetrio Corone (CS)
Villanova Tulo (NU)

I need to get the text between parentheses, I did this

SELECT SUBSTRING(a.place, CHARINDEX('(', a.place) + 1, CHARINDEX(')', a.place, CHARINDEX('(', a.place)+ 1)  - CHARINDEX(')', a.place) - 1)
FROM tab1 a

but I'm getting error about lenght parameter, what's wrong in that?

Tim Biegeleisen · Accepted Answer · 2020-06-23 07:50:36Z

3

Your length input to SUBSTRING is off. The length should be the difference in position between the closing and opening parentheses, offset by one less.

SELECT
    place,
    SUBSTRING(place,
              CHARINDEX('(', place) + 1,
              CHARINDEX(')', place) - CHARINDEX('(', place) - 1) AS abbr
FROM tab1;

Demo

edited Jun 23, 2020 at 7:50

answered Jun 23, 2020 at 7:47

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

1 Comment

marko Over a year ago

Yeah, i Just needed to wait some minutes, I'm doing it now

Collectives™ on Stack Overflow

sql - getting text between parentheses

1 Answer 1

Demo

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Demo

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related