> I use comments in my SQL all the time and have never encountered
> a situation where the parser did anything with them except what
> is expected.

As soon as I remove the comments in the ORDER BY, then it starts working
correctly. So I really presume it has something to do with the ORDER BY
parsing.

> What the monitor is spitting out is alphabet soup, since your
> statement is "unparsable" in the pieces which the IBO parser
> plays with (join criteria, parameters and the WHERE clause).

That is what I figured. If what you say is true, then IBO is the first tool
that dislikes the 1=1 syntax.

Let's wait on what Jason has to tell about this.

--
Jeroen W. Pluimers
Consultant at All I M
http://www.all-im.com