>What I wish SQL Insert permitted the same structure as replace
>
>replace
> this with that, ;
> this1 with that1
>
>is better than
>insert into table ;
>this, ;
>this1;
>values
>that,;
>that1
>
>especially as the length of the command increates.
Ah yes, that's one of those I love to hate. When inserting more than about eight fields, I simply had to wrap each at about four fields, so to preserve some logic for eyeballing the pairs. It becomes a huge PITA when you discover you need to add three more fields and there are fifteen already.