>>I have SET REPORTBEHAVIOR to 90 and it's working fine now since I have SET COMPATIBLE OFF (using LIKE() function as LIKE(someexpression, ALLTRIM(someexpression)).
>>
>>But I have that second problem which I don't know how to solve which is:
>>In reports in 8.0 I have Numerical field with Format: ##,###,###,###,###,###.##
>>In reports those fields are sometimes smaller because of limited space and I check Strech with overflows in order to appear normal, otherwise it would appear asterisk **,***,***,***,***,***.**
>>In 8.0 those fields were working fine but in 9.0 those fields are stretching into another line expanding band making it taller which is totally unexpected for me.
>>How to fix that so that works fine in 9.0?
>
>I think the only way to fix this problem is to slightly expand the field.

I would need to expand it to the max in order to put number in format ##,###,###,###,###,###.## which is too large.
I can't do that. Because if I start to expand all of these fields they would overlap each other and with other fields also, it would be a jungle.
This is serious problem because if I don't make it to work as in 8.0 then whole 9.0 engine to me is useless.