UFN_VALIDMINMAX

Validates that one input is less than the other.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@MIN money IN
@MAX money IN

Definition

Copy


            create function dbo.UFN_VALIDMINMAX(@MIN money, @MAX money)
            returns bit
            with execute as caller
            as begin
                if (@MIN > 0) and (@MAX > 0)
                    if @MIN > @MAX
                        return 0

                return 1
            end