Is there support for xml path in SQL Server 2005 Express Ed?

Hi.

I tried a for xml query in SQL Server 2005 Express Ed. but it says that there is an error near path. I tried the rest of the statements in the query and they were fine. So this led me to ask if it there is for xml path support in SQL Server 20005 Express Edition?

Just in case this has anything to do with it, I have an installed version of SQL Server in my PC too. But I didnt find that in the requirements in installing the Express Edition.

I really need to know this...It's kind of hard having to do the queries in for xml explicit, which works by the way.FOR XML PATH does work in SQL 2005 Express. You want to check your statement syntax to make sure it's right.|||yes, thank you.. I was more careful this time.I still have to check it with the VPS though. Thanks a lot, its reassuring to know that at least that's definitely not a possibility and so the error is still fixable.