Below is an INSERT I use in VB6 for SQL Server. The last variable I sometimes pass as a NULL. When I remove the "" from around the variable the program will not execute. When I place the "" around it as in the example the resulting value is 0 (zero) as the field is an INT (and it allows NULLs). How can I write this so a NULL is valid in the INSERT?
Thanks

cnn.Execute "INSERT INTO SLSalesOrder (" & _
"SLSO_CorporateId, SLSO_CompanyId, SLSO_DivisionId, " & _
"SLSO_Number, SLSO_Date, SLSO_Status, " & _
"SLSO_Type, " & _
"SLSO_Cust_Id, SLSO_Cust_ShipToId, " & _
"SLSO_Instructions, " & _
"SLSO_LineItemCount, " & _
"SLSO_FleetCount, " & _
"SLSO_AssignedTruckId, SLSO_AssignedDate, SLSO_AssignedShift " & _
") " & _
"VALUES " & _
"(" & _
"'" & SavCustomerCorp & "', '000', '000', " & _
"'" & SavSalesOrderNumber & "', '" & SavSalesOrderDateTime & "', '" & SavStatus & "', " & _
"'" & SavCustomerTickType & "', " & _
"'" & SavSLCust_ShipToCustomerId & "', '" & SavSLCust_ShipToId & "', " & _
"'" & SavOrderInstructions & "', " & _
ETicketProductPointer & ", " & _
"'" & SavFleetVehicleCount & "', " & _
"'" & SavAssignedTruckId & "', '" & SavAssignedDate & "', '" & SavAssignedShift & "'" & _
");"