SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [XX](
OrderNO NVARCHAR(20) NULL,
CustomerName NVARCHAR(20) NULL,
Tel1 NVARCHAR(20) NULL,
Tel2 NVARCHAR(20) NULL,
Tel3 NVARCHAR(20) NULL
);
INSERT INTO XX (OrderNO,CustomerName,Tel1,Tel2,Tel3) 
VALUES
('EGS000001','j','88','22','33'),
('EGS000002','p','99','88','66'),
('EGS000003','m','45','22','55'),
('EGS000004','j','91','65','88'),
('EGS000001','n','45','66','22');

SELECT *
FROM XX


OrderNO
CustomerName
Tel1
Tel2
Tel3


EGS000001
j
88
22
33

EGS000002
p
99
88
66

EGS000003
m
45
22
55

EGS000004
j
91
65
88

EGS000001
n
45
66
22


DECLARE @INPUT NVARCHAR(20)
SET @INPUT='77'
SELECT ISNULL(SUM(CASE WHEN TRIM(Tel1)=TRIM(@INPUT) THEN 1 ELSE 0 END +
CASE WHEN TRIM(Tel2)=TRIM(@INPUT) THEN 1 ELSE 0 END +
CASE WHEN TRIM(Tel3)=TRIM(@INPUT) THEN 1 ELSE 0 END),0) AS NUM
FROM XX
WHERE TRIM(Tel1)=TRIM(@INPUT) OR TRIM(Tel2)=TRIM(@INPUT) OR TRIM(Tel3)=TRIM(@INPUT)


NUM


0


DECLARE @INPUT NVARCHAR(20)
SET @INPUT='22'
SELECT ISNULL(SUM(CASE WHEN TRIM(Tel1)=TRIM(@INPUT) THEN 1 ELSE 0 END +
CASE WHEN TRIM(Tel2)=TRIM(@INPUT) THEN 1 ELSE 0 END +
CASE WHEN TRIM(Tel3)=TRIM(@INPUT) THEN 1 ELSE 0 END),0) AS NUM
FROM XX
WHERE TRIM(Tel1)=TRIM(@INPUT) OR TRIM(Tel2)=TRIM(@INPUT) OR TRIM(Tel3)=TRIM(@INPUT)


NUM


3

OrderNO	CustomerName	Tel1	Tel2	Tel3
EGS000001	j	88	22	33
EGS000002	p	99	88	66
EGS000003	m	45	22	55
EGS000004	j	91	65	88
EGS000001	n	45	66	22