SQL如何提取字符串的中间部分

Question

我只想从此字符串中获取单位编号:

'<p>The status for the Unit # 3546 has changed from % to OUTTOVENDOR</p>'

注释始终完全相同，但单元编号发生变化。如何仅提取单位编号？

谢谢!

Answer 1

declare @String varchar(500)

set @String = '<p>The status for the Unit # 3546 has changed from % to OUTTOVENDOR</p>'

select SUBSTRING(@String, charindex('# ', @String) + 2, charindex('has changed', @String) - charindex('# ', @String) - 2)