SQL 如何从SQL中的字符串中提取某些第n个字符

How to extract Certain nth character from a string in SQL

提问by user3383390

I have a field that returns the value as xxx-xxx-xxx-xxxxx-xx-x. How do i extract the 10th character from that code.

我有一个字段返回值为 xxx-xxx-xxx-xxxxx-xx-x。我如何从该代码中提取第 10 个字符。

回答by Joseph B

select substring('xxx-xxx-xxx-xxxxx-xx-x', 10, 1)

The documentation for the function on MSDN is here.

MSDN 上该函数的文档是here.

The SQL Fiddle demo is here(with different letters so you can clearly see which letter is extracted).

SQL Fiddle 演示是here（使用不同的字母，因此您可以清楚地看到提取了哪个字母）。

回答by G one

Use substringfunction

使用substring功能

select substring('xxx-xxx-xax-xxxxx-xx-x', 10, 1)

选择子串('xxx-xxx-xax-xxxxx-xx-x', 10, 1)

回答by christiandev

you can use SUBSTRING, in your case use...

你可以使用SUBSTRING，在你的情况下使用...

SELECT SUBSTRING(field, 10, 1) 

fieldbeing the one that returns the value.

字段是返回值的字段。

回答by mohan111

declare @x varchar(20) = 'xxx-xxx-xxx-xxxxx-xx-x'

select SUBSTRING(@x,10,CHARINDEX('-',@x)-4 )