QUIZ truncation vs varchar

[Murray Scholz]

Can also use formatnumber function... - for other numeric items, it gives you some flexibility 
with decimal places etc... it'll have an implied trunc() , I think ascii() also has 'implied' 
trunc() also.

Something like...

define full-string char*30 = "Account'" + formatnumber(account-code-longinteger,"{}########0") 
+ "'Totals"

Cheers
-- 
Murray Scholz
Agricultural Business Research Institute
University of New England
Armidale NSW 2351 Australia
Email murray.scholz at abri.une.edu.au


fernando.olmos at hpa.com.au wrote:

> I resolved it!
> 
> Sorry guys.
> 
> I simply placed the entire label into a define with a trunc(asc()) set
> of functions to squeeze out the padding spaces.
> 
> Thanks
> 
> -----Original Message-----
> From: Fernando Olmos