Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-04-24 : 02:47:05
|
| how can i complete zero's on a colun that i take if for example the number of chars is les then 10 for example :"werwer" ->"0000werwer""43dgfwesdb" --> no need to completehow can i do this as a part of a select?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-24 : 02:50:03
|
select right('0000000000' + yourcol, 10)
KH |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-24 : 02:51:51
|
| If you use Front end application use Format function thereMadhivananFailing to plan is Planning to fail |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2006-04-24 : 03:05:22
|
| thnasks alot for theright('0000000000' + yourcol, 10) ideaIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
complete zero's