By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select left(v.val1, charindex(' ', v.val1) - 1)
from (values ('4 Matching notifications. 11 inserts/Updates.'),
('4000 Matching notifications. 12 inserts/Updates.'),
('32 Matching notifications. 12 inserts/Updates.'),
('171 Matching notifications. 1 inserts/Updates.')
) t(Investment_Description) cross apply
(values (stuff(t.Investment_Description, 1, charindex('. ', t.Investment_Description) + 1, ''))
) v(val1)
| (No column name) |
|---|
| 11 |
| 12 |
| 12 |
| 1 |