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 SkipVought 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
0
0
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
84
Teamalone
Teamalone
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
131
Miguel93
Miguel93
Janet Charbula
  • Locked
  • Question
Finding a value within a table
Replies
0
Views
57
Janet Charbula
Janet Charbula
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
60
tmcrouse
tmcrouse
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
63
jholl
jholl

Part and Inventory Search

Sponsor

Back
Top