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 - 2001-10-03 : 10:06:06
|
| Kathleen writes "I have a field with $ information in it but is already in my table as a varchar. An example would be '-00000062088 or 000000035880. I need to create a new field that is either numeric or money (I think these are the data types I would want) and then update the varchar contents to it. I've tried the CONVERT and the CAST functions and I've tried making the new field as numeric or money and then simply updating from the varchar field to that field. Nothing is working. How do you do this? What is the actual Transact-SQL language necessary." |
|
|
|
|
|
Convert or Cast varchar to numeric or money