I am still using SQLv6.5 and have a need to do monthly reports. it is my understanding that there is no inherent capability in 6.5 for functions such as MONTH getdate() as exist in SQL 2000. Does anyone know of a script that will simulate this so I can extract information from a database such as date_last_update IN MONTH 02?

Thanks

Dale