>I was wondering if you had a table in the current work area, that had a column name the same as one of your where clause items that wasn't aliased in the select.. but the code sample you posted didn't so I dismissed that possibility. I should have gone ahead and asked anyway, it might have gotten you to the solution a little faster.

Well, the help received was also helpful for me as it allowed me to provide by order of elimination. Then, I went back to the SQL itself and found something in it today. :)