This is an indication that your data is poorly structured.

you are using a text field to represent a binary value (Pass/fail)

I would suggest the introduction of a lookup table

declare @TestStatus as table

(

TestStatusDescription nvarchar(50),

TestResult int

)

insert into @testStatus (TestStatusDescription,TestResult) values ('OK',1)

insert into @testStatus (TestStatusDescription,TestResult) values ('Pass',1)

insert into @testStatus (TestStatusDescription,TestResult) values ('Fail',0)

insert into @testStatus (TestStatusDescription,TestResult) values ('Not OK',0)

...

one record for every description in your table: you can find these by doing a SELECT DISTINCT on the relevant field.

Then join to this @TestStatus table to return 1 or 0 and use the MIN() functionality to determine whether any test has failed.