sql - Split a value in T-SQL

Question

I have a value in one column like this: PD 10256-P1.

I want to split this information & only need the number 10256.

How to achieve this?

标签： sqlsql-server

Answer 1

你可以很容易地做到这一点

SUBSTRING('PD 10256-P1', 4, 5)

它将您的输入从第 4 个字符开始减少为 5 个字符串。

结果是

10256

阅读更多