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