clear markdown compare help best fiddles feedback
clear markdown feedback
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 E000498) | 01
E000710 Clarify why backlog is 0 E000710 Clarify why backlog is 0
 hidden batch(es)