SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU3) (KB4538853) - 15.0.4023.6 (X64) 
	Mar  4 2020 00:59:26 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE SampleValues (TextID INT, Comment VARCHAR(MAX) )
INSERT INTO SampleValues (TextID, Comment)
SELECT 1, 'user 1 has done crosswalk 99220 to 99215 and submitted' UNION
SELECT 2, 'got update that crossedwalked 99308 to 99221' UNION
SELECT 3, '99255 CROSSWALKED TO 99223' UNION
SELECT 4, 'proposed crosswalk 99219 to 99214 and clean' UNION
SELECT 5, 'tested and confiimed cross walked code from 99223 to 99255' UNION
SELECT 6, 'User 2 Crosswalked codes change 99254 to 99222' UNION
SELECT 7, 'User3cross walked code from 99232 to 99307' UNION
SELECT 8, 'Updated to 99307'
8 rows affected

select comment,  NULLIF(SUBSTRING(comment
							, PATINDEX('%[0-9][0-9][0-9][0-9][0-9]%', comment)
								, CASE WHEN CHARINDEX(' ', comment, patindex('%[0-9][0-9][0-9][0-9][0-9]%', Comment)) - PATINDEX('%[0-9][0-9][0-9][0-9][0-9]%', comment) < 0 THEN 0
									ELSE CHARINDEX(' ', comment, patindex('%[0-9][0-9][0-9][0-9][0-9]%', Comment)) - PATINDEX('%[0-9][0-9][0-9][0-9][0-9]%', comment) END ), '')
+ ' to ' + NULLIF(REVERSE(substring(REVERSE(comment)
						, patindex('%[0-9][0-9][0-9][0-9][0-9]%', REVERSE(comment))
							, CASE WHEN CHARINDEX(' ', REVERSE(comment), patindex('%[0-9][0-9][0-9][0-9][0-9]%', REVERSE(Comment))) - patindex('%[0-9][0-9][0-9][0-9][0-9]%', REVERSE(comment)) < 0		THEN 0 ELSE CHARINDEX(' ', REVERSE(comment), patindex('%[0-9][0-9][0-9][0-9][0-9]%', REVERSE(Comment))) - patindex('%[0-9][0-9][0-9][0-9][0-9]%', REVERSE(comment))	 END )),'') AS Extracted
from SampleValues							


comment
Extracted


user 1 has done crosswalk 99220 to 99215 and submitted
99220 to 99215

got update that crossedwalked 99308 to 99221
99308 to 99221

99255 CROSSWALKED TO 99223
99255 to 99223

proposed crosswalk 99219 to 99214 and clean
99219 to 99214

tested and confiimed cross walked code from 99223 to 99255
99223 to 99255

User 2 Crosswalked codes change 99254 to 99222
99254 to 99222

User3cross walked code from 99232 to 99307
99232 to 99307

Updated to 99307
null

comment	Extracted
user 1 has done crosswalk 99220 to 99215 and submitted	99220 to 99215
got update that crossedwalked 99308 to 99221	99308 to 99221
99255 CROSSWALKED TO 99223	99255 to 99223
proposed crosswalk 99219 to 99214 and clean	99219 to 99214
tested and confiimed cross walked code from 99223 to 99255	99223 to 99255
User 2 Crosswalked codes change 99254 to 99222	99254 to 99222
User3cross walked code from 99232 to 99307	99232 to 99307
Updated to 99307	null