sql server取 字符串开头的左边右边
2025-02-20 本文已影响0人
吉凶以情迁
ccc001取 字符和取001
经过测试发现PATINDEX 够用 用[^a-z] 找到非字符的index,
DECLARE @str NVARCHAR(100) = 'aaack00001'
SELECT PATINDEX('%[^a-z]%', @str )
SELECT LEFT(@str, PATINDEX('%[^a-z]%', @str ) - 1) AS ExtractedNumbers
SELECT right(@str, PATINDEX('%[^a-z]%', @str ) - 1) AS ExtractedNumbers
``
