I$\text{'}$m trying to get only the ending number of the store limit$.$ I did this, but I$\text{'}$m still getting additional characters I don't want to include. How can I exclude them?

$$

DROP TABLE #Store

$$ CREATE TABLE #Store

$($

$[$Description$]$ varchar$(250)$

$)$;

INSERT INTO #Store $([$Description$])$

VALUES $(\text{'}$Store Pricing Plan #$0000000$ modified.$$ Store Limit changed from NULL to $8610\mathrm{.}0\text{'}),$

$(\text{'}$Store Pricing Plan #$1111111$ modified.$$ Store Limit changed from NULL to $2620\mathrm{.}0$ Sotred Pricing Program changed from NULL to Sale Pro Plan'$),$

$(\text{'}$Store Pricing Plan #$2222222$ modified.$$ Store Price changed from $1\mathrm{.}999000$ to $1\mathrm{.}819000$ Store Limit changed from $15000\mathrm{.}0000$ to $5500\mathrm{.}0$asdfghj Plan Name'$),$

$(\text{'}$Store Pricing Plan #$3333333$ modified.$$ Store Limit changed from $32100\mathrm{.}0000$ to $123455\mathrm{.}0\text{'}),$

$(\text{'}$Store Pricing Plan #$4444444$ modified.$$ Store Limit changed from $941\mathrm{.}0000$ to $142\mathrm{.}2$ Money Limit changed from $1100\mathrm{.}69$ to $426\mathrm{.}51\text{'}),$

$(\text{'}$Store Pricing Plan #$5555555$ added.$$ Store Price: $2\mathrm{.}60$ date from $11/01/2024$ to $10/31/2025\text{'})$

$$

SELECT

$$ #Store.$[$Description$],$

$$ CASE WHEN

$$CHARINDEX$(\text{'}$Store Limit changed from $\text{'},$ #Store.$[$description$])>0$ AND CHARINDEX$(\text{'}$to $\text{'},$ #Store.$[$Description$],$ CHARINDEX$(\text{'}$Store Limit changed from $\text{'},$ #Store.$[$Description$]))>0$ THEN

$$ LEFT$($SUBSTRING$($#Store.$[$Description$],$ CHARINDEX$(\text{'}$to $\text{'},$ #Store.$[$Description$],$ CHARINDEX$(\text{'}$Store Limit changed from $\text{'},$ #Store.$[$Description$]))+3,$ CHARINDEX$(\text{'}\text{'},$ #Store.$[$Description$]+\text{'}\text{'},$ CHARINDEX$(\text{'}$to $\text{'},$ #Store.$[$Description$],$ CHARINDEX$(\text{'}$Store Limit changed from $\text{'},$ #Store.$[$Description$]))+3)-$ CHARINDEX$(\text{'}$to $\text{'},$ #Store.$[$Description$],$ CHARINDEX$(\text{'}$Store Limit changed from $\text{'},$ #Store.$[$Description$]))-3),8)$

$$ELSE NULL

$$ END 'Store Limit'

FROM #Store