'SQL query to get values between multiple parentheses

I need to get the values from withing a parentheses and sum them together. An example string is as follows

12233LT112(70) 12324AM331(80)

I want to sum the values in the parentheses, so in this example, it would sum to 150.

Is there any good way to solve this? Thanks in advance!

sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions