>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.