Andrew Schmidt, I'm having trouble reproducing this with SQL Server. What version of SQL Server are you using and which dialect are you using?