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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trim leading zeros in a data value

Status
Not open for further replies.
james0816

james0816

Programmer
Jan 9, 2003
295
US
I am pulling data in as "000050". I want to trim those leading zero's to be "50". how do you do this using SQL?

thx
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
508
bharons
bharons
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
744
BobThornton
BobThornton
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
657
EdLentz
EdLentz
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
554
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
582
lupidol
lupidol

Part and Inventory Search

Sponsor

Back
Top