At 03:21 PM 2/11/2002, Seth Bienek wrote: >Uhh.. Kinda.. I pasted my query into the SQL Server query building tool >because >it's quicker to debug than running the dynamic page I'll be using it on.. I >keep having to go back and remove those extra parens and re-space everything. Seth.... Try the Query Analyzer tool. It plays better with human formatted SQL. Plus it will parse and validate too. I find this tool the best to try out queries that build before I move them into ASP. ---- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."