By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601523 fiddles created (47953 in the last week).
create function dbo.E00_Part(@title varchar(100))
returns varchar(100)
as
begin
return (select Reverse(Substring(@title, CharIndex('E00',@title), 100 )))
end
✓
hidden batch(es)
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))
✓
hidden batch(es)
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
Bank Payments Testing Solution (E000498) | 01 Discover
