Hi All,

I'd like to be able to do the following query in Oracle.

lcSql = "SELECT LEGALHOL.* " + ;
"FROM LEGALHOL " + ;
"WHERE YEAR(LEGALHOL.HoliDate) = " + TRANS(lnActiveYear)

lnHandle = sqlexec(gnSatHandle, lcSql, 'Holiday_Cursor')

But I guess the YEAR() fuction is not valid in Oracle.

TIA
Mike