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 - 2005-05-13 : 08:10:16
|
| Diego writes "Hi, I imported data from a txt file to a sql server table. One column is a varchar and the data is 03/08/1969. This column must be varchar not DATE. So, my problem is that I have to convert those numbers in the form 03081969 without slashes. So my original data is 03/08/1969 and now must be 03081969 How can I convert them?Thanks!!!!" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-13 : 08:48:54
|
| update table set datecolumn=replace(datecolumn,'/','')MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Alter data in a column in sql server