create table table_1
(
col1 varchar(100)
)
insert into table_1
values
('EQ181'),
('TX 116-3860')
Select
col1
,SUBSTRING(col1,1,Minimun-1) as col1
,SUBSTRING(col1,Minimun,data-Minimun+1)
from
(
select col1,min(N) as Minimun,DATALENGTH(col1) as data from table_1 cross apply Tally
where SUBSTRING(col1,n,1) like '%[0-9]%'
group by col1
) as a
You may...