clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 984296 fiddles created (11703 in the last week).

CREATE TABLE #Demo ( [Tag Type] char(1) NOT NULL, [Parent Tag Type] char(1) NULL, [Tag Area No] integer NOT NULL, [Tag seq No] integer NOT NULL, [Tag Suffix] char(1) NULL, [Tag] AS CONCAT([Tag Type], [Parent Tag Type], [Tag Area No], [Tag seq No], [Tag Suffix]) );
 hidden batch(es)


INSERT #Demo ([Tag Type], [Parent Tag Type], [Tag Area No], [Tag seq No], [Tag Suffix]) VALUES ('T', NULL, 1234, 1, NULL), ('T', 'P', 5678, 1, 'S');
2 rows affected
 hidden batch(es)


SELECT * FROM #Demo AS D;
Tag Type Parent Tag Type Tag Area No Tag seq No Tag Suffix Tag
T 1234 1 T12341
T P 5678 1 S TP56781S
 hidden batch(es)