We help IT Professionals succeed at work.
Get Started

Alter Column nvarchar to Money

JohnB344
JohnB344 asked
on
610 Views
Last Modified: 2012-05-11
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
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE