SQL SERVER||How to get Nth Letter from String?

select name,SUBSTRING(name,3,1) as Third_Letter from emp
Select name,LEFT(RIGHT(name,Len(name)-2),1)as Third_Letter from emp