Hey Folks, Sorry for the off topic question.
I have 2 columns in the DB that need to be converted from a VarChar to Decimal. I have noticed in the past that using Alter Table will throw an error if data is going to be truncated or cannot be changed. There are probably 250,000 records and of course I am leery about doing this so I don't mux the data. I am planning to copy some of the data to another table to experiment on before doing the big change. I assume NULL will stay NULL as other changes have been like this. I have changed numeric data before with no problems but this the first time converting from a VarChar. There are around 5000 records that I will need to "fix" in order to do this before moving forward. Does anyone see any problems with doing this this way? Thanks for any feedback... ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
