Help Me With SP OrderBy

I have a SP that accepts parameters, but the problem is that it is not ORDERING Data as required, It is returning ORDER BY NULL instead of order by my parameter "NAME "here is the output from SQL 2000 DB





'ELP B4 I jump out of LondonBridge





**********************************


SELECT * FROM #TempTable WHERE ID > 0 AND ID < 6 AND EmployerID = 54 AND Job_no = 40





ORDER BY NULL


****************************************











SELECT @MYSTATEMENT = ' SELECT * FROM #TempTable





WHERE


ID > '+ convert(varchar(20),@FirstRec) +'


AND


ID < '+convert(varchar(20),@LastRec) +'


AND EmployerID = '+ convert(varchar(20),@EmployerID)+'


AND Job_no = '+convert(varchar(20),@Job_no)+'





ORDER BY ' +


CASE WHEN @WhichColumn= 'name' AND @sortby= 'asc'


THEN 'name'


ELSE 'NULL'


END


+


CASE WHEN @WhichColumn='name' AND @sortby='DESC'


THEN ' desc'


ELSE ''


END





EXEC (@myStatement)