UFN_CONSTITUENCY_GETDESCRIPTION

                CREATE function dbo.UFN_CONSTITUENCY_GETDESCRIPTION(@ID uniqueidentifier)
                returns nvarchar(100)
                as begin
                    declare @DESCRIPTION nvarchar(100);

                    select
                        @DESCRIPTION = CONSTITUENCYDEFINITION.DESCRIPTION
                    from
                        dbo.CONSTITUENCYDEFINITION
                    where
                        CONSTITUENCYDEFINITION.ID = @ID;

                    if @DESCRIPTION is null or @DESCRIPTION = ''
                        select
                            @DESCRIPTION = CONSTITUENCYCODE.DESCRIPTION
                        from
                            dbo.CONSTITUENCYCODE
                        where
                            CONSTITUENCYCODE.ID = @ID;

                    return @DESCRIPTION;
                end