UFN_EDUCATIONALINSTITUTION_GETCITYFROMCONSTITUENT

      create function dbo.UFN_EDUCATIONALINSTITUTION_GETCITYFROMCONSTITUENT
      (
        @EDUCATIONALINSTITUTIONID uniqueidentifier
      )
      returns nvarchar(150)
      with execute as caller
      as begin
          declare @RETVAL nvarchar(150);

        select @RETVAL = ADDRESS.CITY
        from dbo.CONSTITUENT
                  inner join dbo.ADDRESS
            on ADDRESS.CONSTITUENTID = CONSTITUENT.ID 
                where (ADDRESS.ISPRIMARY = 1) and
              (CONSTITUENT.ID = @EDUCATIONALINSTITUTIONID);

          return @RETVAL;
      end