>>cmdInsertTrans.CommandText = "sp_InsertTransactions " & cLng(Transaction_ID ) & "," & "'" & company & "'" & "," & prefix & "," & suffix
>>
>>-Mike
>
>I made one error in my last response. The company field is evaluating to " ".
>
>Bob

If you declared the company parameter as VARCHAR in sp_InsertTransactions, SQL Server is behaving correctly. In 6.5 you cannot have an empty, or zero-length, VARCHAR variable.

-Mike