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!

Trim 0's 1

Status
Not open for further replies.
zatch

zatch

MIS
Oct 11, 2001
75
US
I have varchar field whose data looks similar to this:

0000345
0023456
0123456
0000001

What I need to do is "trim" the zero's from the beginning of each record.

Any help is greatly appreciated.

Zatch
 
Sort by date Sort by votes
Code: 
select cast(yourfield as numeric)

[bandito] [blue]DBomrrsm[/blue] [bandito]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
1K
gmmastros
gmmastros
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
406
gmmastros
gmmastros
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
356
Volvere
V
Andrzejek
  • Locked
  • Question
SSMS question 1
Replies
4
Views
673
Sana Shazadi
S
Brianfree
  • Locked
  • Question
SQL Rank() But move 0 values to bottom of Rank?
Replies
1
Views
106
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top