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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-18 : 20:00:39
|
George writes "I have a column with phone numbers. Some of these rows have other characters to the right of the first 10 characters of the phone numbers such as:
1234567890abcd efgh (currently)
1234567890 (want it like this)
and I'm trying to update the data on this column so that I don't have any characters to the right of the data (after the 10 characters). The column has a varchar(25) format. Is there a way to do this without exporting the data, cleaning it up and re-importing it again? Please let me know. Thanks.
PS - Could you please provide me the exact sql syntax (I'm very new at SQL). Thanks again." |
|
|
|
|
|
Deletetion of partial data in a column