[dbo].[decimal]

(local) > mdb > Scalar-valued Functions > dbo.decimal

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@num	float	8
@num2	int	4
@num3	int	4

SQL Script

/****** Object:  User Defined Function dbo.decimal    Script Date: 12/1/2005 11:50:33 PM ******/

CREATE FUNCTION [dbo].[decimal](@num float(53), @num2 int=0, @num3 int=0 )
RETURNS float(53) AS
BEGIN
    RETURN convert(float(53), round(@num, 0, 1)) + convert(float(53), left(convert(varchar, abs(round(@num, 0, 1) - @num)), 2 + @num3))
END
GO

Uses

[dbo].[varchar]
dbo