SQL question 2

[lalitha1]

How can I convert Varchar value to Money in sql server 2000.

 

[gmmastros]

Try this:

Varchar 2 money

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[lalitha1]

I get this error since its not a recognized func name.Any help.
Server: Msg 195, Level 15, State 10, Line 5
'varchar2money' is not a recognized function name.

Before that i got this error:
Disallowed implicit conversion from data type varchar to data type money, table A, column 'Charge'. Use the CONVERT function to run this query.

 

[gmmastros]

Try:

Convert(Money, Charge) As Charge




-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[lalitha1]

It works great Thanks!

 

[tcsbiz]

Varchar 2 money

That is hilarious, George. The link worked perfectly. Have a star.

 

[xxing]

George

I enjoyed your link of how to google for an answer.

However, this could be a beginner who asked the question

 

[JoeAtWork]

George - I gave you a star for making me LOL !

Only trouble is I will now be tempted to use that for every forum answer I give!

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[gmmastros]

George

I enjoyed your link of how to google for an answer.

However, this could be a beginner who asked the question

I mean no disrespect, but I am sometimes surprised that someone will post a question and wait for a reply instead of using google. Granted, there are times when google results in too many results, and you just don't know where to start. There are other times when you don't know the correct terminology, so google doesn't display any relevant results. It could also be that the OP had never heard of google.

In any event, I don't think my post was disrespectful or even a little out of line. However, if you think there was anything inappropriate about it, I encourage you to click the 'Inappropriate post' link. Make sure you give Dave a good reason to remove the post, and he probably will.




-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom