Re: Formatting out blanks

In article <2jr2kt$5jq_at_paperboy.gsfc.nasa.gov>, joefw_at_daac.gsfc.nasa.gov writes...
>...
>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:
>...

Very straight-forward.

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

Peter Grant, I.S.P.   ////////  ///////  ////////  //    //  //    //  ////////
grant_at_triumf.ca         //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia

             Communications Officer, Vancouver Oracle Users Group
  ***************************************************************************

• WESTERN ORACLE USERS CONFERENCE * JUNE 17, 1994 * UBC CAMPUS, VANCOUVER *

  ---