Formatting out blanks

Maybe I missed something in the manuals, but I can't see how to easily do the following:

I want to create an output with a number from the database inside of a text string. The width of the number varies from 1 to 5 digits. My script currently looks like this:

	set space 0
	select 'ABC',item_no,'DEF' from item;

My goal is to have output formatted as:
	ABC123DEF
	ABC4DEF
	ABC4467DEF

but instead get:
	ABC   123DEF
	ABC     4DEF
	ABC  4467DEF

(assuming numformat is set to 999999).

Any suggestions?

Thanks.

Joe Woytek
joefw_at_daac.gsfc.nasa.gov
Code 902.2
NASA/GSFC Received on Tue Feb 15 1994 - 19:01:00 CET