>>>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
Exactly! I fixed it and now it is evaluating to " ".
:-)Bob
Database Development Team