>Does SQL Server have the capability of storing a stored procedure in a varchar or text field and then calling that stored procedure from another (currently executing) stored procedure.
>
>I'm looking for an equivalent to VFP'c ability to use macrosubtitution to store program logic in a variable and then execute it when desired.
>
You can use dynamic SQL with EXECUTE command or sp_executesql stored procedures. See
Re: Using a variable in the FROM clause of a SELECT Message #
877130 and
Re: Dynamic SQL Thread #
907431, for example. Check also
How to return a value from dynamicaly executed T-SQL code FAQ #8130.
--sb--