Re: SQL - pad a string to fill up to a certain length?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 14 Apr 2006 13:14:00 -0400
Message-ID: <GuOdnRjOg9jARaLZnZ2dneKdnZydnZ2d@comcast.com>

"dean" <deanbrown3d_at_yahoo.com> wrote in message news:1145034218.102587.269630_at_t31g2000cwb.googlegroups.com...
: Is there a command that will take a string (vcarchar2), and (if its
: less that N characters long, PAD it will spaces until it is N
: characters long? Like the reverse of TRIM.
:
: Thanks!
:
: Dean
:

yes it's called PAD --- well, sort of. LPAD or RPAD

++ mcs Received on Fri Apr 14 2006 - 12:14:00 CDT

This message: [ Message body ]
Next message: Mark C. Stock: "Re: Table join expertise needed badly"
Previous message: Brian L: "Table join expertise needed badly"
In reply to: dean: "SQL - pad a string to fill up to a certain length?"
Next in thread: dean: "Re: SQL - pad a string to fill up to a certain length?"
Reply: dean: "Re: SQL - pad a string to fill up to a certain length?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US