I have a VARCHAR column with data like this:

```
abc = :abc and this = :that

```

I need a query to find all of the special "words" that start with a colon in this column of data. I don't really need any other data (IDs or otherwise) and duplicates would be OK. I can remove duplicates in Excel later if need be. So if this was the only row, I'd like something like this as the output:

```
SpecialWords
:abc
:that

```

I'm thinking it'll require a CHARINDEX or something like that. But since there could be more than one special word in the column, I can't just find the first : and strip out the rest. 

Any help is greatly appreciated! Thanks in advance!