I tried the new sql, and it's still not giving me any results, Rudy. I know that it's the database giving me grief here because I've tried simpler queries and they've all worked with the equivalent php code. Any advice? Lach