Could you please maybe make it a little more clear what this code is?
Is it the definition of an object from Designer? (If so, then this question belongs in the Designer Forum.)
Is it the SQL generated by a query panel? If so, then is numeric or alpha – because if it should be alphanumeric, the 100 should be in quotes. But if it is from the query panel, BusinessObjects should have taken care of it.
Or is it FreeHand SQL?
Finally, saying that your getting “an error” is not very helpful – please tell us what the error is.
Whatever it is, then you should be more explicit about what you’re doing, and not leave us guessing.
It’s happening in reporter. The problem is that the WHERE construct doesn’t allow for anything but = as an operator. It also doesn’t allow for anthing but a constant on the right side of the =. Your formula doesn’t fit that.
Perhaps you could use an if-then-else construct instead.