UPDATE ct
SET [text] = CASE WHEN ct.longflag = 1 THEN CAST(ct.[text] AS VARCHAR(MAX)) ELSE ct.shorttext END
			+ '; ' + REPLACE(i.shortnarrative, '*Fixed fee for ', '') + '; '
FROM casetext ct
INNER JOIN inserted i ON ct.caseid = i.caseid
WHERE ct.texttype = '_B'
AND ct.longflag = 1
AND SUBSTRING(i.shortnarrative, 1, 1) = '*'

UPDATE ct
SET ct.shorttext = CASE WHEN LEN(ct.shorttext) + LEN(i.shortnarrative) < 252
						THEN ct.shorttext + ' ' + + REPLACE(i.shortnarrative, '*Fixed fee for ', '') + '; '
						ELSE NULL
				   END,
	ct.longflag	=  CASE WHEN LEN(ct.shorttext) + LEN(i.shortnarrative) < 252
						THEN ct.longflag
						ELSE 1
				   END,
	ct.[text]   =  CASE	WHEN LEN(ct.shorttext) + LEN(i.shortnarrative) < 252
						THEN ct.[text]
						ELSE ct.shorttext + '; ' + REPLACE(i.shortnarrative, '*Fixed fee for ', '') + '; '
				   END
FROM casetext ct
INNER JOIN inserted i ON ct.caseid = i.caseid
WHERE ct.texttype = '_B'
AND ct.longflag <> 1
AND SUBSTRING(i.shortnarrative, 1, 1) = '*'

INSERT INTO casetext(caseid, texttype, textno, class, [language], modifieddate, longflag, shorttext, [text])
SELECT i.caseid, '_B', 0, NULL, NULL, NULL, 0, REPLACE(i.shortnarrative, '*Fixed fee for ', '') + '; ', NULL
FROM inserted i
WHERE NOT EXISTS
(
	SELECT *
	FROM casetext ct
	WHERE ct.caseid = i.caseid
	AND ct.texttype = '_B'
)
AND SUBSTRING(i.shortnarrative, 1, 1) = '*'

if (select count(*) from inserted where wipcode = 'P001') = 1
		begin
			delete from inserted where wipcode in ('P009SC', 'P092SC', 'P9A1SC', 'P9A2SC', 'P9P9SC')
		end