SELECT
  CASE
    WHEN CHARINDEX('  ', prd_name) > 0
     AND CHARINDEX('  ', prd_name, CHARINDEX('  ', prd_name) + 2) > 0
    THEN SUBSTRING(
           prd_name,
           CHARINDEX('  ', prd_name) + 2,
           CHARINDEX('  ', prd_name, CHARINDEX('  ', prd_name) + 2)
             - CHARINDEX('  ', prd_name) - 2
         )
    ELSE prd_name
  END AS color
FROM tf_pss
WHERE ps_no = :ps_no AND itm = :itm;