Which Dot Net string function is equivalent to get specific character in Sql Server?

Substring is the right answer.It is used to extract part of the string from specified string.We can specify starting index and length of the string.It has three arguments like below:-
Syntax:-
Substring(string_expression,start_position,string_length);