Alter Column nvarchar to Money

JohnB344
JohnB344 used Ask the Experts™
on
I have a table that I get and I want to change an nvarchar(50) value to Money.
My column looks like:
0000500.00
0005190.00
0000100.00
I want to convert to Money but I get, Disallowed implicit conversion from data type nvarchar to data type money.
I know I can right click on the table and change this, but how can I do it in an Alter Column Stmt? If I try to do an Update or Convert before the Alter I get the opposet error...
Disallowed implicit conversion from data type money to data type nvarchar
I know this is probably easy, but I can't seem to get it done without right clicking on the table and selecting money.... then it's no problem!
Thanks In advance, jb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Commented:
alternatively, you can:

1) rename the current column to something else, like 'X'
2) create a new column of type money with the original column name
3) update yourTable set newCol = convert( money, X )
4) drop column X
JohnB344

Author

Commented:
Thanks alot, glad someone is thinking today!!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial