SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE example (
  x INT,
  y INT
);

INSERT INTO example VALUES
  (5, 1256),
  (384, 38412),
  (1, 5236);
3 rows affected

SELECT x, y, CASE WHEN CHARINDEX(CONVERT(VARCHAR, x), CONVERT(VARCHAR, y)) > 0 THEN 1 ELSE 0 END
FROM example


x
y
(No column name)


5
1256
1

384
38412
1

1
5236
0


SELECT x, y, CASE WHEN CONVERT(VARCHAR, y) LIKE '%' + CONVERT(VARCHAR, x) + '%' THEN 1 ELSE 0 END
FROM example


x
y
(No column name)


5
1256
1

384
38412
1

1
5236
0


SELECT x, y, CASE WHEN PATINDEX('%' + CONVERT(VARCHAR, x) + '%', CONVERT(VARCHAR, y)) > 0 THEN 1 ELSE 0 END
FROM example


x
y
(No column name)


5
1256
1

384
38412
1

1
5236
0


SELECT x, y, CASE WHEN REPLACE(CONVERT(VARCHAR, y), CONVERT(VARCHAR, x), '') <> y THEN 1 ELSE 0 END
FROM example


x
y
(No column name)


5
1256
1

384
38412
1

1
5236
0


CREATE FUNCTION dbo.ContainsNumber (@y INT, @x INT)  
RETURNS BIT
AS
BEGIN
  RETURN CONVERT(BIT, CHARINDEX(CONVERT(VARCHAR, @x), CONVERT(VARCHAR, @y)))
END
SELECT x, y, dbo.ContainsNumber(y, x) 
FROM example


x
y
(No column name)


5
1256
True

384
38412
True

1
5236
False