Re: Formatting out blanks

>>>>> "Peter" == Peter A Grant <grant_at_erich.triumf.ca> writes:  

> Very straight-forward.
 

> select 'ABC'||item_no||'DEF' from item;

To get the padding right you need:

  select 'ABC' || rpad(item_no, 5) || 'DEF' from item;

--
--
Mike Eggleston       American Airlines Decision Technologies     
(817)931-2287        P. O. Box 619616, MD 4462                            
(817)967-9763 (FAX)  Dallas/Fort Worth Airport, Texas 75261-9616, USA
Only my opinions.