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. 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 E000089>,
 hidden batch(es)