In case you were wondering how, I figured it out... 😀

CASE WHEN PATINDEX('%[^0-9]%', [ts].[DESCRIPTION]) > 0

THEN LEFT(SUBSTRING([ts].[DESCRIPTION], PATINDEX('%[0-9]%', [ts].[DESCRIPTION]),

CHARINDEX('%', [ts].[DESCRIPTION] + SPACE(1), CHARINDEX('%', [ts].[DESCRIPTION]))), 2)

ELSE [ts].[DESCRIPTION]

END AS [STRGH]