Try below
declare @t table (col1 varchar(20), col2 varchar(20))
INSERT INTO @t VALUES
('732', 'abc')
,('732', 'xyz')
,('732', 'rrt')
,('6784', 'rre')
,('6784', 'oop')
,('56', 'u7h')
,('56', 'wwt')
SELECT * FROM @t WHERE '732887' LIKE '%' + col1 + '%'