Ok here's where were at now:
We got the script to work
SELECT CASE WHEN '[REQD.P.P_OVERALL_TOTAL]' < 250000 Then 'Yes' ELSE 'No' END from dual
And the expected result is correct (YES), but the workflow wont transition to the next step because of an "invalid result" error:
Go to Solution.
...or possibly Y or N depending on which validation your step is using...