Something like this?
CREATE TABLE #SomeValues (SomeData VARCHAR(50));
INSERT #SomeValues (SomeData)
VALUES
('1101BRZ')
,('BRZ')
,(' 1101BRZ')
,(' BRZ 1101')
,(' INSP');
SELECT
sv.*
, Cleaned = IIF(t.trimmed LIKE '1101%', STUFF(t.trimmed, 1, 4, ''), t.trimmed)
FROM #SomeValues sv
CROSS APPLY
(SELECT trimmed = LTRIM(RTRIM(sv.SomeData))) t;
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.