Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I zero fill left justify in a select???

Status
Not open for further replies.
Rhinohd

Rhinohd

Technical User
Nov 29, 2005
4
US
How do I create a left justified, zero filled (leading zeros for a total 10 bytes) result from this select? The field is (DECIMAL 9,2)...

Code: 
Select
sum(d.PRICE) as "Dollars"

I need the results to be formated like this sample..
00000123.54
00000069.95

Rather then this
123.54
69.95

Thanks In Advance!
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
167
Teamalone
Teamalone
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
280
Miguel93
Miguel93
Janet Charbula
  • Locked
  • Question
Finding a value within a table
Replies
0
Views
111
Janet Charbula
Janet Charbula
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
129
tmcrouse
tmcrouse
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
123
jholl
jholl

Part and Inventory Search

Sponsor

Back
Top