Ok: I do the response.write(SQL) bit and this is what I get:<BR>INSERT INTO NCONTACT VALUES (10, 'Conor', 'Crowley', ' ', ' ', ' ', , ' ') <BR>The second value from the end is an integer field and it is here that I have the problem. When a value is present the statement works perfectly. When no value has been entered there are two consecutive commas which produces a syntax error. How can I overcome this without having to write 2 insert statements which deal with the two possible scenarios (value present and value absent)? I cannot use this solution as I would then have to write in the region of a few thousand insert statements to cover all possibilities in my database.<BR>Thanks for any help in advance. I'm very grateful.