-- Test table with some rubbish data
DECLARE @Test TABLE
(
	Names [varchar](20)
)
INSERT INTO @Test
SELECT 'Simon'

-- Query returns but with XML_<GUID> alias
SELECT 
	Names
FROM 
	@Test t 
FOR XML PATH ('Test')

/* If you're using SQL2005+ you could try something this */
;
WITH  CTE ( Test )
        AS ( SELECT  Names
             FROM    @Test t
             FOR     XML PATH('Test')
           )
   SELECT   Test ,
            CAST(Test AS XML) AS Test
   FROM     CTE

-- Test table with some rubbish data
DECLARE @Test TABLE
(
	Names [varchar](20)
)
INSERT INTO @Test
SELECT 'Simon'

-- Query returns but with XML_<GUID> alias
SELECT (SELECT 
	Names
FROM 
	@Test t 
FOR XML PATH ('Test') ) as Test