Q:

T-SQL - How to remove text to the left of a specific character

I have a table that returns variable string lengths in the format below:
Example Text: More example text

How do I remove all the text before the colon and the colon to leave just the text to the right of the colon, so I have the result of:
More example text

The text to the right can be any length.
Thanks

A:

This was the answer that worked for me. Script.Topic is the column name:
SELECT RIGHT('{Script.Topic}', len('{Script.Topic}') - charindex(':', '{Script.Topic}'))

