SQL server move data from one column to another

Question

I have a table like below:

Id value
1. Doc
1. Doc
1. Doc
2. Txt
2  Txt

I only want to display "doc" in a new column using alias. How can I do it?

Stas · Answer

If you need just split one column with 3 letters like in your example, you could use RIGHT function:

SELECT Id, RIGHT(Id, 3) FROM yourTable