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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-08-08 : 10:23:52
|
| hey i like to remove 1 digit from the start of a column.example i've data in a column which as a 0 at the start of it0123456i like to remove the 0 so am only left with 123456 |
|
|
pootle_flump
1064 Posts |
Posted - 2008-08-08 : 10:32:51
|
| If you want a string returned or the first character may not be 0, look up SUBSTRING in BoL. If you require a number returning, you could try CASTing to an integer. |
 |
|
|
bjoerns
Posting Yak Master
154 Posts |
Posted - 2008-08-08 : 11:09:32
|
| Too bad they never reveal their datatypes. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-08-08 : 11:09:59
|
| thanks i used the substring and it worked fine in the update. |
|
|
|
|
|
|
Remove 1 digit