declare @Sample table (Proj_name varchar(100))
insert @Sample
select '123.234-martiinternational.pdf' union all
select '22356.2894-martiinternational.pdf' union all
select '6758.1287-papa.pdf'
I want to get the second part from right between dot and hypen
which is 234, 2894 and 1287
Thank you very much for the helpful info.