problem with SQL function & decimal in ADP

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top