LISTING 3: Code to Concatenate Eyes and Nose SELECT CASE WHEN key_col IN(2,3,max_key-1,max_key-2) THEN REPLICATE('/',4) ELSE SPACE(4) END + CASE WHEN key_col IN(max_key/2,max_key/2+1) THEN REPLICATE('/', 8) ELSE SPACE(8) END FROM #Words CROSS JOIN (SELECT MAX(key_col) AS max_key FROM #Words) AS R ORDER BY key_col