Thanks... How I missed values is beyond me. Just goes to show that sometimes the second pair of eyes works when the obvious is missing

Thanks

Here is actual code in vb.net

myCommand = New SqlCommand

("insert into invoices

('" & RouteNumber & "','" & Route_date & "','" & txtStop.Text & "','"

& txtCust.Text & "','" & txtInv.Text...

printing my command text looks good

"insert into invoices (' 113','8/23/2010','5','938886 ','9632587','75326.21','Totes','8','cartons','4','cigs','8','hba','3','N','0','0','0','0','0','0')"

but paste in sql manager and run query got me this

Msg 103, Level 15, State 4, Line 1

The identifier that...

if you look at the set up of mycommand in the first part of my post I have ending paren after conn2.

When I go into immediate window and print mycommand.commandtext...

I have ending ) after the , conn2). Tried putting it after the last '0'"), conn2 but it through up error about missing paren

I have it after the last 0 then a , anc then conn2)