My 2c: get php for it. You may do it with SQL functions to get the date month, year etc and than concatanete them (again using SQL functions). At least it is possible in Sybase and MS SQL Server. However, this means that you are injecting some unnecessary business logic to your database layer. Although it is debatable, mixing business tier and data tier is generally not a good practice. HTH, Volkan. -- Volkan Ozcelik +>Yep! I'm blogging! : http://www.volkanozcelik.com/volkanozcelik/blog/ +> My projects/studies/trials/errors : http://www.sarmal.com/