如何从SQL中的字符串中提取某些第n个字符 [英] How to extract Certain nth character from a string in SQL

问题描述

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

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.

推荐答案

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

MSDN 上该函数的文档位于此处.

The documentation for the function on MSDN is here.

SQL Fiddle 演示在 这里(使用不同的字母，以便您可以清楚地了解看看提取的是哪个字母).

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

这篇关于如何从SQL中的字符串中提取某些第n个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！