Hi Michael,

You can use ODBC scalar function:

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

MartinJ

>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