>Hi Michael,
>
> You can use ODBC scalar function:
>
>

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

>
> MartinJ

Hi Martin,

Outstanding. Thanks. That was what I needed.

Mike