It worked... thanks!!!!

ALTER  FUNCTION dbo.ProductCategoryTree

(

   @CategoryID int

)

RETURNS varchar(200)

AS

BEGIN

        DECLARE @return varchar(200)

        DECLARE @category int

        DECLARE @categoryname varchar(200)

        SET @return = ''

        SET...

Thanks everybody!  This is so much faster than looking in BOL

Scott