_IBM_,
declare @t table(xz varchar(20))
insert into @t
select ' 11 Текст' union all
select ' 22.2 Текст' union all
select ' 1.1 Текст.Текст' union all
select ' 3.3 Текст'
;with cte as
(select xz, cast('<a>'+replace (xz, ' ', '</a><a>')+'</a>' as xml) as xz1 from @t)
select t1.xz, t2.val
from cte t1
cross apply
(select t.c.value('text()[1]', 'varchar(10)') as [val]
from t1.xz1.nodes('/a') as t(c))as t2
where isnumeric(t2.val)=1
xz val
-------------------- ----------
11 Текст 11
22.2 Текст 22.2
1.1 Текст.Текст 1.1
3.3 Текст 3.3
зы
про то, что isnumeric - считает "числом" - ищи по форуму дополнительно