Stored procedure with dynamic order by clause

Group,
I would like to create a procedure that will accept a parameter that
will allow the stored procedures result set to be ordered based on
parameters.
Any help would be greatly appreciated.

Create Procedure Proc_GetTodaysWorkload( inUserID Int, inSortCol Int )
Begin
Select <Field Names>
Joins <Tables Names>
Where c.NameID = inUserID
Order By inSortCol -- This doesn't work
End;