Microsoft OLE DB Provider

I have tried to create a stored proc in SQl server.The query is like this: CREATE PROCEDURE sp_GetMemberList (@spstr_condn varChar(255)) AS SELECT * FROM tbl_member order by @spstr_condn . But an error was generated.

Microsoft OLE DB Provider for SQL Server (0x80040E14)

The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.