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-02-12 : 09:12:10
|
Chris writes "Hi,
I work for CSC (Computer Sciences Corp), and work with web apps all day... I'm pretty much an expert on SQL statements with Oracle, but I came across a project that is using MS SQL-Server... I am trying to update a money field in the database, but it's giving me the following error :
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type varchar to data type money, table 'ICD.dbo.tblOS_OffsetManagement', column 'ProgramValue'. Use the CONVERT function to run this query.
I've tried using the CONVERT function but then it gives me invalid syntax.. And believe me, I've tried every type of syntax both myself and the Oracle DBA could think of... I appriciate the help
-Chris" |
|
|
|
|
|
SQL: MONEY FIELD UPDATE