It might be too late but maybe other are interested:

'Value' = (

CASE

WHEN t.Result in ('Fail','No','0.00') THEN '0.00'

WHEN t.Result in ('Pass','Yes') THEN '1.00'

ELSE CONVERT(VARCHAR, CAST(t.result AS float))

END),

OR

'Value' =...