 <p>If you will never have dots, you can use this</p> <pre><code>PARSENAME(REPLACE(ColumnName,':','.'),1) </code></pre> <p>example</p> <pre><code>DECLARE @v VARCHAR(100) = 'DT:CSDF' SELECT PARSENAME(REPLACE(@v,':','.'),1) </code></pre> <p>otherwise use PATINDEX and RIGHT</p> <pre><code>SELECT RIGHT(ColumnName,LEN(ColumnName) -PATINDEX('%:%',ColumnName)) </code></pre> <p>Example</p> <pre><code>DECLARE @v VARCHAR(100) = 'DT:CSDF' SELECT RIGHT(@v,LEN(@v) -PATINDEX('%:%',@v)) </code></pre>