Yes, I typed the message incorrectly. My code does have the @.

>Hi!
>
>Shouldn't it be following?
>
>EXEC spCompanyInsert @CompanyID = 1, @PrincipalBusinessDescription = "Blah Blah Blah"
>
>
>
>>I am fairly new to SQL Server, and am having trouble using VFP 6.0 SP4 to insert a record into a SQL Server 7.0 table. I am using SQLExec to call a stored procedure, spCompanyInsert. The Company table has a text field, PrincipalBusinessDescription, which is giving me trouble.
>>
>>I am building a string in VFP for the SQLExec call: [EXEC spCompanyInsert @CompanyID = 1, PrincipalBusinessDescription = "Blah Blah Blah"]. When I issue the SQLExec, SQL Server bombs. I think I need to use ' rather than " to delimit the parameters, but sometimes my memo field contains a '.
>>
>>My questions are:
>>
>>1. Should I be using a Text fiel in SQL Server? I upsized from a VFP database, and the source field was a memo field.
>>2. Is using a stored procedure the best way to handle inserting and updating records, or shoudl I just issue the INSERT from VFP?
>>3. When I am building my SQL string in VFP, what do I do if one of the parameters to the sproc contains a '?
>>
>>TIA