problem with SQL function & decimal in ADP

[Guest]

Losing what's left of my hair over this one, cannot get this to work. Access
2003
-----------------------------------------------------------------------------
FUNCTION dbo.mbtest
(@parameter decimal(3,2) )
RETURNS decimal(3,2)
AS
BEGIN
select @parameter = @parameter
RETURN @parameter
END

----------------------------------------------------------------

If I run this from an ADP and input 5.5 it returns 5, if I input .5 it
returns 0

Actually I have a much more complex function that does not work, but this is
the essence of my problem. Does not see the value to the right of the decimal
poiint.

What am I missing?

Thanks!!
MB

 

[Guest]

oops- wrong forum, I'll re-post in ADP SQL