UFN_REVENUEGLDISTRIBUTION_VERIFYACCOUNTNUMBER

CREATE function [dbo].[UFN_REVENUEGLDISTRIBUTION_VERIFYACCOUNTNUMBER](@AccountNumber nvarchar(100))
            returns bit    
            with execute as caller
            as
            begin

            declare @retval bit = 0

            if exists (select * from GLACCOUNT where ACCOUNTNUMBER = @AccountNumber)
                set @retval = 1
            else
                begin
                if dbo.UFN_GLACCOUNT_EXISTS() = 0
                    set @retval = 1
                end 

            return @retval                 
        end