SELECT * FROM  (
    SELECT LEN(Code) AS largo FROM fp.DealCode
)
AS Q
WHERE largo = 8

;WITH Q
 AS (
    SELECT LEN(Code) AS largo FROM fp.DealCode
)
SELECT * FROM Q
WHERE largo = 8