fnUserName

      CREATE Function [dbo].[fnUserName](@PKID int) returns nvarchar(150) as
      begin
      declare @name nvarchar(150)

      declare @FIRST nvarchar(50)
      declare @MIDDLE nvarchar(5)
      declare @LAST nvarchar(50)

      select top 1 @FIRST = FirstName, @MIDDLE = MiddleInitial, @LAST = LastName
      from dbo.CLIENTUSERS where ID = @PKID

      declare @PEOPLEID int
      select @PEOPLEID = BOSU.BACKOFFICEPEOPLEID from dbo.BackOfficeSystemUsers BOSU where BOSU.CLIENTUSERSID = @PKID

      if 1 = (select [PRIVATE] from dbo.ClientUserFieldPrivacy CUFP where CUFP.BackOfficeSystemPeopleID = @PEOPLEID and CUFP.FIELDID = 2)
      set @FIRST = ''

      if 1 = (select [PRIVATE] from dbo.ClientUserFieldPrivacy CUFP where CUFP.BackOfficeSystemPeopleID = @PEOPLEID and CUFP.FIELDID = 3)
      set @MIDDLE = ''

      if 1 = (select [PRIVATE] from dbo.ClientUserFieldPrivacy CUFP where CUFP.BackOfficeSystemPeopleID = @PEOPLEID and CUFP.FIELDID = 4)
      set @LAST = ''

      Select @name = (case when len(isnull(@FIRST,''))>0 then
      @FIRST + ' ' else '' end) +
      case when len(isnull(@MIDDLE,''))>0 then
      left(@MIDDLE,1) + '. ' else '' end + isnull(@LAST,'')
      from [dbo].ClientUsers
      where ID=@PKID

      return isnull(@name, '')
      end