I think it is 4K (not sure though)
Because VFP use sp_executesql to execute your code and that SP requires nvarchar for parameters, and the maximum chars in nvarchars are 4000.


>Kevin,
>
>I could. I could build the sql string (which I am reading in from vfp tables) and pass it as a parameter to the SP. Does that have an impact on the string limit, if there is one, or let me do something I couldn't do otherwise?
>
>One reason I'd rather avoid sp's - even though I know of their benefits, is that I want to be able to install this app, easily in multiple client sites, without modifying their database. I'm using Accountmate's VAM/SQL software, and when they come out with a new release of the software or database, I will have additional complexity to deal with if I add SP's, because then I'll have to modify the upgraded database.
>
>In any event though what I'm concerned about is running up into a limitation on the string size on a single sql command, so I'm hoping to find that out, whether via inline sql or SP.
>
>Thanks
>
>
>>David,
>>
>>Have you considered using stored procedures?
>>
>>Kevin