Ok, I think I have figured out the problem with Alltrim() not trimming.

I am passing the status field of the contract into the function through an SQL select. SQL columns have to be a set width, which stands to reason, so consequently, when I pass the field over, SQL sets the column width up as c(20) which is the same as the field that the value is coming from. Now that makes sense, what still gets me is the fact that the value is being passed into the function as a parameter and it is the parameter itself which cannot be trimmed, it is as if the SQL has fed through to the function and made this parameter read only, although UPPER() still works ok.

The workaround I have made is just to make the various array elements 20 character wide as well and padded them out with spaces. Messy, but at least I can get on with things now.

Thanks for all the replies.

Ashley
AssuerSoft