How would I replicate useing a macro substitution inside a stored procedure that I have created? What I want to create is a standard select expression with the various parts decided by what paramters are being passed to the procedure. The standard statement in VFP would look like this:

select * from &fromclause where &whereclause order by &orderclause

How could I mimick this in SQL server?

Thanks in advance
Kelly