> Could you please let me know for the syntax in FOR XML AUTO, ELEMENTS > in SQL , what is the firebird compliance
This is Microsoft SQL Server specific. There is nothing similar built-in into Firebird. There are tools out there which can help you to export data to XML. -- With regards, Thomas Steinmaurer http://www.upscene.com/
