>>Kevin,
>>
>>one more vote for the first option. Whereas the second option appears "neater", I find it more difficult to tie in which WITH goes with which field name if the space is too large between them (I think my eyes are lopsided :)).
>
>Yeah. Who wants to use a ruler to read code. You'll get fingerprints on the screen!
>
>I've had a similar complaint with INSERT-SQL
>
>INSERT INTO TABLE (;
> FIELD1, ;
> FIELD4, ;
> FIELD2, ;
> FIELD3, ;
> FIELD6, ;
> FIELD5, ;
> FIELD8, ;
> FIELD9 ;
> ) ;
> VALUES ;
> (;
> 'A', ;
> 'D', ;
> 'B', ;
> 'C', ;
> 'F', ;
> 'E', ;
> 'G', ;
> 'H', ;
> 'I' ;
> )
>
>Why does the above line not give me the correct result? field1 gets a to field9 gets I.
no field7?