Hi

Is there a function or an workaround that removes the trailing spaces.

TRIM has a parameter to specify the outfield length and the outfield.i dont want to specify those as they are dynamic and no way to catch those.

Is there any way??

You may want to look at SQUEEZ (note lack of ending E).
You say that you can not catch the output field name - you should really think about that again and the output length.

Navin,

It sounds like what you are trying to do is pass a fieldname as an ampher variable. You can use ARGLEN to capture the length.

That is solved by TRUNCATE() function . .
Thanks all for ur comments . . .