UFN_VSECONSTITUENCY_ROWEXISTS

            create function dbo.UFN_VSECONSTITUENCY_ROWEXISTS(
                @VSECONSTITUENCYCODE tinyint
                )
            returns bit
            with execute as caller
            as begin
                declare @ROWCOUNT int;

                select
                    @ROWCOUNT = count(ID)
                from
                    dbo.VSECONSTITUENCY
                where 
                    VSECONSTITUENCYCODE = @VSECONSTITUENCYCODE
                if (@ROWCOUNT <= 1)
                    return 1;

                return 0;
            end