Money!!

[Nicolas]

Hi!
I have a field with money datatype, but!! It can't received a value like
"41331237"!!!
I can't understand why not!!!
Who knows why?

Thank you!

Nicolás

[Lia]

Try using the CONVERT function in your sql string.
Something like "INSERT into myTable (field1,moneyfield)
VALUES('testvalue', CONVERT(money, '41331237')"


Lia



"Nicolas" <nsaf@hotmail.com> wrote:
>
>Hi!
>I have a field with money datatype, but!! It can't received a value like
>"41331237"!!!
>I can't understand why not!!!
>Who knows why?
>
>Thank you!
>
>Nicolás
>