>Hi Naomi,
>Thanks for the suggestions. What would it take to get it ANSI compatible Can someone help with an example? That way I can set the enginebehavor to 9.0? correct?
>thank you and everyone for your advice and help.
>Alp
In order to make it ANSI compatible you need to move all fields not used in GROUP BY to some AGGREGATE function, such as MIN/MAX/AVG
If it's not broken, fix it until it is.
My Blog