Is there any way where we can have functions in groupby while firing a SQL statement to visual foxpro.

Eg: select jobno,year(eta) from jobmast group by year(eta)

The above SQL gives an error. THe roundabout way is

select jobno,year(eta) as yr from jobmast group by yr

The above SQL Statement works fine, but the OLAP tool which connects to visual foxpro database generates the 1st SQL statement. And the report dosen't go through.

Regards
Ravi