How can I get some text between two known words? 

Sub-select example:

```
(SELECT TOP(1)Note
FROM Clients
WHERE (ID=@ID) AND (Note IS NOT NULL) AND (Note NOT LIKE '%Damaged%')) AS Note

```

This returns:

```
Blablabla bla bla blabla bla bla bla (21.08.2015) "some text" word bla bla
Blablabla bla bla blabla bla bla bla (25.08.2015) "another text" word bla bla 
Blablabla bla bla blabla bla bla bla (28.08.2015) "TEXT I NEED TO GET" word bla bla blabla bla bla.

```

So I need to get text between last ")" and last "word"

Tried some magic but it didn't work with last ")" and last "word"