pivot

hi

we're working with sql 2008 and 8.8 pl 15.

we get an error when trying to run a query with a pivot function.

"1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DA 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement (OCTR) (s) could not be prepared."

what can i do to resolve this?

raf