SQL Server 2019

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

select *
into t
from (values ('f v / 45.23698 , sdfsdf'), ('25.369 xzczxc xcvxv'), ('erwer ewrwr 2.36')) v(field)
3 rows affected

select t.*, s.value
from t cross apply
     string_split(t.field, ' ') s
where try_convert(float, s.value) is not null


field
value


f v / 45.23698 , sdfsdf
45.23698

25.369 xzczxc xcvxv
25.369

erwer ewrwr 2.36
2.36


select t.*, v.str,
       left(v.str, patindex('%[^0-9.]%', v.str + ' ')) as val
from t cross apply
     (values (stuff(t.field, 1, patindex('%[0-9]%', field) - 1, ''))) v(str)


field
str
val


f v / 45.23698 , sdfsdf
45.23698 , sdfsdf
45.23698

25.369 xzczxc xcvxv
25.369 xzczxc xcvxv
25.369

erwer ewrwr 2.36
2.36
2.36

field	value
f v / 45.23698 , sdfsdf	45.23698
25.369 xzczxc xcvxv	25.369
erwer ewrwr 2.36	2.36

field	str	val
f v / 45.23698 , sdfsdf	45.23698 , sdfsdf	45.23698
25.369 xzczxc xcvxv	25.369 xzczxc xcvxv	25.369
erwer ewrwr 2.36	2.36	2.36