UFN_FACULTY_ISADVISOR

        create function dbo.UFN_FACULTY_ISADVISOR
        (
            @FACULTYID uniqueidentifier
        )
        returns bit
        with execute as caller
        as begin
            declare @retval bit = 0

            if exists(
                select 
                    dbo.FACULTY.[ISADVISOR]
                from 
                    dbo.FACULTY
                where 
                    dbo.FACULTY.[ID] = @FACULTYID and dbo.FACULTY.[ISADVISOR] = 1)
            set @retval = 1

            return @retval
        end