Posted by Lee on 02/12/07 22:56

hi

I've just tried that (in SQL 2005)

SELECT subtring(Ms, 1, datalength(Ms) / 2 - 1
FROM (SELECT [company size] + ' ' AS [text()]
FROM results
FOR XML PATH('')) AS T(Ms)

and its returns errors, is that a working example?

Thanks
Lee

• Next in forum: attn: tiphanie - truly energetic postings - ifja wur - (1/1)
• Prev in forum: Re: returning one single record rather than multiples
• Thread view: Re: returning one single record rather than multiples

[Reply to this message]