Implicit conversion varchar to money not allowed?

[Spork52]

Documentation for T-SQL says that the conversion from varchar to money is implicit (

http://msdn.microsoft.com/en-us/library/ms187928.aspx

see chart about 1/3 down the page).

But, when I try inserting into a money column like this:

sql = "INSERT INTO myTable (myMoney) VALUES ('" &  replace(somemoney, "'","''") & "')"

(where somemoney is a string. e.g., 38.25)

I get this error:

Disallowed implicit conversion from data type varchar to data type money, table 'myTable', column 'myMoney'. Use the CONVERT function to run this query.

But this works:

sql = "INSERT INTO myTable (myMoney) VALUES (" &  replace(somemoney, "'","''") & ")"

Is the documentation wrong or is my understanding wrong? Or, is the conversion implicit only in certain circumstances?

 

[TheBugSlayer]

It' s not, the intersection cell falls on the diagonal and it' s empty. Sorry.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)

 

[TheBugSlayer]

Ah, sorry, I take that back. It is implicit.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)