I'm inserting decimals into Sql server database
datatype decimal percision 18, scale 2.  It will round
my number up or it removes the last digit if it is a
zero.  How do I avoid both of these things?

cmd.Parameters.Append cmd.CreateParameter("Param4",
adInteger, adParamInput)
cmd("Param4") = 23.53


i've tried changing the CreateParameter to adDecimal,
but it gives an percision is incorrect error.
thanks

__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/