SQL SERVER - How get substring from string

Get 2 chars from position 6:

select substring( 'This is text', 6, 2 ) 

Output:

----
is

(1 row(s) affected)