Actuate BIRT Designer Professional - Select statement with Case and Like clause

[hmax]

Actuate BIRT Designer Professional
Version: 11.0.4
Build id: 20121023

Select statement - need to retrieve field results based upon two "like" scenarios.

E.g,.
Select
Table1.Field1,
Table2.Field2,
Case
If Table1.Field1 like ('%pass%') then "PASS"
If Table1.Field1 like ('%fail%') then "FAIL"
Else Table1.Field1
End
From
Table1,
Table2
Where
etc.

Coming from an SAP BO background, new to Actuate. Grateful for your help!

Thank you.

hmax