a single string is limited to 255 characters. Break this up into say 3 char variables such as cSQL1, cSQL2 and cSQL3 and then concatonate them back using
something like cSQL = cSQL1 + cSQL2 + cSQL3. Seems odd but it will indeed work...

>How can I get this SQL string to work. It is too long but I need all the info
>
>testthissd = "INSERT INTO drawmstrp"+;
>"(dm_drawing_number,dm_drawing_title,dm_pending_change,"+;
>"dm_date_issued,dm_requester_name1,dm_requester_name2,"+;
>"dm_job_order,dm_project,dm_customer,dm_size,dm_sheets)"+;
>"Values"+;
>"(&nfn,"+"&nf2,"+"&nf3,"+"&nf4,"+"&nf5,"+"&nf6,"+"&nf7,"+"&nf8,"+"&nf9,"+"'E'"+",1)"