By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employee (
EmployeeID INT,
FullName VARCHAR(100) -- Column for Full Name (string)
);
INSERT INTO employee (EmployeeID, FullName) VALUES
(1, 'Stewie Griffin'),
(2, 'Peter B Griffin'),
(3, 'Lois Griffin'),
(4, 'Brian O''Connor'),
(5, 'Meg Griffin');
SELECT
SUBSTRING(FULLNAME, 1, 1)
+REPLICATE('*', CHARINDEX(' ', FULLNAME) - 2)
+SUBSTRING(FULLNAME, CHARINDEX(' ', FULLNAME), LEN(FULLNAME) - CHARINDEX(' ', FULLNAME) + 1)
FROM employee;
| (No column name) |
|---|
| S***** Griffin |
| P**** B Griffin |
| L*** Griffin |
| B**** O'Connor |
| M** Griffin |