Re: SQL comments

> Found them, eventually.
> I was trying to insert a comment in the middle of a line:
>
> select status, reason, --method
> from....
>

Actually, you can put a comment in the middle of a line. Your mistake
in the above statement is because of the comma before the command, the
parser sees this:

select status, reason, from ....

it's completely legal to write:
select status, reason --method
from mytable         -- line 2

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook