By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table1(Column1 NVARCHAR(100), Column2 NVARCHAR(100));
INSERT INTO Table1 (Column1, Column2) VALUES
(41391175, 41000),
(41523664, 41523),
(110505116, 110509),
(110453629, 110505),
(41000, 351592);
SELECT Column1
FROM Table1 AS t
WHERE EXISTS (
SELECT 1
FROM Table1 AS x
WHERE t.Column1 LIKE x.Column2 + '%'
)
| Column1 |
|---|
| 41523664 |
| 110505116 |
| 41000 |