SELECT	cfcifno,
	cffrnm,
	cfltnm,
	cfisexcod,
	cfissn,
	cfimobil,
	cadrphon,
	CADRFAX,
	cadremail,
	cfjobcode,
	tbdptype,
	tcd_cfcifno,
	tdserial,
	cadrdsc1,
	cadrphon_office
FROM	(
		SELECT	cfcifno,
			cffrnm,
			cfltnm,
			cfisexcod,
			cfissn,
			cfimobil,
			cadrphon,
			CADRFAX,
			cadremail,
			cfjobcode,
			tbdptype,
			tcd_cfcifno,
			tdserial,
			cadrdsc1,
			cadrphon_office,
			CASE 
				WHEN LEN(CADRFAX) < 7 THEN 7
				WHEN LEN(CADRFAX) >= 10 THEN 10
				ELSE LEN(CADRFAX)
			END AS y1,
			CASE 
				WHEN LEN(CadrPhon) < 7 THEN 7
				WHEN LEN(CadrPhon) >= 10 THEN 10
				ELSE LEN(CadrPhon)
			END AS y2,
			CASE 
				WHEN LEN(CfiMobil) < 7 THEN 7
				WHEN LEN(CfiMobil) >= 10 THEN 10
				ELSE LEN(CfiMobil)
			END AS y3,
			CASE 
				WHEN LEN(cadrphon_office) < 7 THEN 7
				WHEN LEN(cadrphon_office) >= 10 THEN 10
				ELSE LEN(cadrphon_office)
			END AS y4
		FROM	Customer 
	) AS d
WHERE	RIGHT(CadrFax, y1) = RIGHT('2184840001', y1)
	OR RIGHT(CadrPhon, y2) = RIGHT('2184840001', y2)
	OR RIGHT(CfiMobil, y3) = RIGHT('2184840001', y3)
	OR RIGHT(cadrphon_office, y4) = RIGHT('2184840001', y4)

WHERE
	CadrFax IN ('2184840001', '184840001', '84840001', '4840001')
	OR CadrPhon IN ('2184840001', '184840001', '84840001', '4840001')
	OR CfiMobil IN ('2184840001', '184840001', '84840001', '4840001')
	OR cadrphon_office IN ('2184840001', '184840001', '84840001', '4840001')