If you want a result for every row, then use a case statement to make the result as you wish when "CED:" is present.

If you only want results for rows that do contain "CED:", then use a where clause to limit.