SQL Get char at position in field

In SQL Server you can use SUBSTRING

SELECT SUBSTRING('hello', 3, 1)

Take care: index is 1-based.