if isnull({test.state}) or {test.state}= '   ' then 'hello' else 'hi' and see if you get hello for state where it is null may be some records have spaces in them which are not nulls....

 

cheers

rahul