This is the easiest way, though it may not work for what your actual query is but...

-- 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