如何在sql server中的字符串中找到第n个字符？

如何在sql server中的字符串中找到第n个字符？



这里我有一个字符串，我想找出第n个字符那个字符串。



例如：字符串是'Hemanth'



如果我想找出来第5个字符我必须得到'n'7'字符我必须得到'h'这样的。怎么做？有人帮我吗？

how to find nth occurrence of character in a string in sql server?

Here i have a string and i would like to find out the n'th character of that string.

for example: string is 'Hemanth'

if i want to find out 5'th character i must get 'n' 7'th character i must get 'h' like this. how to do it? some one help me?