I'm not sure how Alvin's query solved the problem as the LIKE operator will implicitly convert values into strings.
DECLARE @test-2 TABLE(
Numbers int)
INSERT INTO @test-2 VALUES(12),(75924),(75),(53756),(2354)
SELECT Numbers
,Case when Numbers like '75%' THEN 'True' ELSE 'False' END
,CASE WHEN CAST(Numbers AS VARCHAR) LIKE '75%' THEN 'True' ELSE 'False' END
,CASE WHEN LEFT(CAST(Numbers AS VARCHAR), 2) = '75' THEN 'True' ELSE 'False' END
FROM @test-2
You can change the Numbers data type to any type that can be implicitly converted and you'll get the same result for the different options. You'll have more problems with the input values than with the LIKE operator.