getPigeonNames

set  ANSI_NULLS  ON
set  QUOTED_IDENTIFIER  ON
go


ALTER   FUNCTION   [ dbo ] . [ getPigeonNames ]
(
     @FanciersID   UniqueIdentifier  
)
RETURNS   varchar ( 2000 )
AS
BEGIN
     declare   @Names   as   varchar ( 2000 )
     Set   @Names   =   ''
     Select   @Names   =   @Names   +   ' , '   +  Name 
         From  Pigeons  Where  FanciersID  =   @FanciersID   AND  Status = 1

     SET   @Names = ( Select   substring ( @Names , 2 , len ( @Names )))

     RETURN   @Names
END