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.

Thanks,

CTBlankenship