Click on the "View" tab and select "Output" in BIDS. This will show you the execution result/progress in the output window below. Once done you can select all the rows/lines...

if the resultset is not very big then the simplest way of doing is,

SELECT *, CASE Result1 < 100 Then something as Results2

FROM (Select .. VERY LONG FORMULA as Results1)...