How do I extract text that lies between parentheses (round brackets)?

I have a string User name (sales) and I want to extract the text between the brackets, how would I do this?

I suspect sub-string but I can’t work out how to read until the closing bracket, the length of text will vary.