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