How to simulate TRANSFORM function from SQL server (Crosstab query)

Hi!
Have to port one application from SQL server to Interbase. In SQL server
they are using "TRANSFORM" function in SQL statement to get Crosstab query.
Any idea how to implement that in Interbase?
Regards,
FDF
_________________________________________
ICQ#:97321897 Current ICQ status: SMS: (Send an SMS message to my ICQ):
+278314297321897 More ways to contact me: http://wwp.icq.com/97321897
_________________________________________