Create a temp view for the table/view with (IYR4(ChkDate)) included as a named column.
Then use that column in your query and group by Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Gray, Damon Sent: Wednesday, December 17, 2008 11:45 AM To: RBASE-L Mailing List Subject: [RBASE-L] - How can I legally do this Group By? At the end of my simple query, I have this group by clause that is illegal. How can I do this legally? WHERE IYR(CHKDATE) IN (2004, 2005, 2006, 2007) GROUP BY IYR(CHKDATE), PRHIST.EID, PRHIST.LNAME, EMPLOYEE.FIRSTNAME Damon J. Gray Anvil Corporation Business Services (360) 937-0770
