SQL Server 2016

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

create function dbo.E00_Part(@title varchar(100))
returns varchar(100)
as
begin
	return (select Reverse(Substring(@title, CharIndex('E00',@title), 100 )))
end
create table T (title varchar(100), Computed as Iif(title like '%E00%',Reverse(Substring(dbo.E00_Part(title),patindex('%[0-9]%',dbo.E00_Part(title)),100)),null))
insert into T values 
		('ProALPHA - S - HTML Custom Table implementation (E001445)'									),
		('IKA CP Implementation (Aus) (E001534-0001)'																	),
		('Test Engagment Integration: (E001637-0003) Non-billable'										),
		('Customer requests customization for Analytics and Java Migration - E000797'	),
		('Create list with customers renewing in H2 2020'															),
		('Bank Payments Testing Solution (E000498) | 01 Discover'),
		('E000710 Clarify why backlog is 0')

select * from t


title
Computed


ProALPHA - S - HTML Custom Table implementation (E001445)
E001445

IKA CP Implementation (Aus) (E001534-0001)
E001534-0001

Test Engagment Integration: (E001637-0003) Non-billable
E001637-0003

Customer requests customization for Analytics and Java Migration - E000797
E000797

Create list with customers renewing in H2 2020
null

Bank Payments Testing Solution (E000498) | 01 Discover
E000498) | 01

E000710 Clarify why backlog is 0
E000710 Clarify why backlog is 0

title	Computed
ProALPHA - S - HTML Custom Table implementation (E001445)	E001445
IKA CP Implementation (Aus) (E001534-0001)	E001534-0001
Test Engagment Integration: (E001637-0003) Non-billable	E001637-0003
Customer requests customization for Analytics and Java Migration - E000797	E000797
Create list with customers renewing in H2 2020	null
Bank Payments Testing Solution (E000498) \| 01 Discover	E000498) \| 01
E000710 Clarify why backlog is 0	E000710 Clarify why backlog is 0