QUIZ truncation vs varchar

[fernando.olmos at hpa.com.au]

Hi again gang.

Here is a tricky one...

I have a program is I am trying to get it to report some string chars
with a numeric value and have the numeric value enclosed in single quote
chars.

i.e.:	Account '123456' totals: ... blah blah blah

The blahs are the columns I am reporting, which is not the problem.

The problem I am having is how to actually print the account number
within the quotes, without QUIZ passing out the field.

This is what I am actually getting ...

	Account '  123456  ' total: ... etc

The 123456 value comes from an Integer size 4 with a pic "^^^^^^".

I tried simply saying trunc(accountno) in the report item, but QUIZ
rejects putting functions into report items, something which is really
annoying.

I also tried a define with a varchar * 6 to see if the varchar would by
default trim off the spaces. It made no difference.

Something in QUIZ is telling it to put the spaces between the single
quote chars.

Any help appreciated.

Thanks