>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.