substring - T-Sql Extract order number within a string -

substring - T-Sql Extract order number within a string -

i trying homecoming order number off of string such listed below. i've tried charindex left , right , substrings no avail. using actual info order number can anywhere 9 12 characters.

declare @string varchar(max) = 'your order number purchase 012345678 , appreciate business'

any assistance appreciated.

thanks in advance, m.butter

patindex can used regular look search find order number

%[0-9]%

once index found, substring can used order number

declare @var varchar(max) = 'your order number purchase 012345678 , appreciate business' declare @sub varchar(max) select @sub=substring(@var,patindex('%[0-9]%', @var), len(@var)) select substring(@sub, 0, charindex(' ', @sub))

sql substring charindex