> > Perhaps it would be better to write an UDF in which
> > you decode the date, subtract 100 years and encode
> > it again. That way, the leap years are included.
>
> Yeah, but if the date is a 29.02., you would also have to check if the
> calculated year is also a leap year (e.g. 29.02.2000 minus 100 years ->
> 28.02.1900 ?)

Right... :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com