By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601414 fiddles created (47998 in the last week).
CREATE TABLE T
(
title NVARCHAR(MAX) NOT NULL
,Computed AS
REPLACE(
CASE CHARINDEX('E00', title)
WHEN 0 THEN
NULL
ELSE
SUBSTRING(
title
,CHARINDEX('E00', title)
,CHARINDEX(' ', title + ' ', CHARINDEX('E00', title)) - CHARINDEX('E00', title)
)
END
,')'
,''
)
);
✓
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'),
('E000060: Set end date to 30.5.2021'),
('First Corporation (UK) - HQ-Fiserv ED CO3 (E000586-0004)_Dan S'),
('CA DMV - Performance testing (E001504)(Load)'),
('D-MS-GIP: Testmanagement & Test Data Management (& automation) (E000123), billable EM resource, remote, EMEA'),
('Twinformatics U - S - Consulting Roll out (E000089)>, <EM Resource, <remote>, EMEA')
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
E000710 Clarify why backlog is 0
E000710
E000060: Set end date to 30.5.2021
E000060:
First Corporation (UK) - HQ-Fiserv ED CO3 (E000586-0004)_Dan S
E000586-0004_Dan
CA DMV - Performance testing (E001504)(Load)
E001504(Load
D-MS-GIP: Testmanagement & Test Data Management (& automation) (E000123), billable EM resource, remote, EMEA
E000123,
Twinformatics U - S - Consulting Roll out (E000089)>, <EM Resource, <remote>, EMEA
