Update with data conversion

[SProc]

Hello there,

I am trying to update a field of type money, but I keep getting an error message "Disallowed implicit conversion from data type varchar to data type money". I need to use convert, but it doesn't seem to be working.
Here is my syntax:
update posted_jrnl_line
set trans_amt= '0.0000'
where jrnl_id = 'TRA123457'
Could any help.
Thanks!

 

[MeanGreen]

I am guessing that this would work even though you say the convert would not:

update posted_jrnl_line
set trans_amt= convert(money,'0.0000')
where jrnl_id = 'TRA123457'

Let me know if this does not work.
Hope this helps.