Hi,

I have an SQL Stored Procedure to list the categories in my DB as follows:

 CREATE Procedure CategoryList
AS
SELECT 
	ID,
	Title,
	Description,
	MoreInfo
FROM 
	Categories
ORDER BY
	ID ASC
GO

What I need to do is vary the way results are ordered by. Ideally I'd have :
ORDER BY
@OrcerBy ASC
but it doesn't work.

Any ideas?

Regards,

Minaki

Got it.
In case anyone was wondering, http://dotnetjunkies.com/WebLog/seic.../20/11769.aspx