SELECT Feature,

Status=CASE WHEN patindex('Err%',RunStatus)>0 THEN 'Err*'

WHEN patindex('Fail%',RunStatus)>0 THEN 'Fail*'

WHEN patindex('Pass%',RunStatus)>0 THEN 'Pass*'

ELSE 'Other'

END,

[Count]=count(1)

FROM...