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 |
|
tjforce
Starting Member
8 Posts |
 Posted - 2006-01-24 : 16:34:15
|
| I need help converting data. I have a varchar field called v and a decimal field called d. The varchar field contains data, i.e. 285000, 152525, etc. I need to update field d with the correct value, i.e. 2850.00, 1525.25, etc. How would I accomplish this? |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-01-24 : 17:38:34
|
| Lookup CAST OR CONVERT in Books Online... |
 |
|
|
|
|
|
Data Type Conversion