How to use dynamic order by in SQL server function

See more:

SQL-Server

I have to pass parameter from front end based on requirement then based on that parameter the function would be sorted..

So how can I provide sorting feature in function
Please help me..

ALTER FUNCTION [dbo].[Func_GetCamp]
(
 @YearID int,
 @FederationID int,
 
 @SortOrder VARCHAR(MAX)
)
RETURNS 
@GetStateDistributionSummary TABLE 
(
 campaignID int,
 campaignName varchar(100),
 campaignControlNumber int,
 DistributionID int,
 AllocationDate datetime,
 DistributionNumber int,
 DistributionAmount decimal(18,2)
)
AS
BEGIN
 
 IF(@CampaignTypeID=0)
	BEGIN
		SET @CampaignTypeID=null
	END
	
	
SET @SortOrder = @SortOrder
 INSERT INTO @GetStateDistributionSummary
 
	SELECT
		campaign.campaignID,
		campaignName =
		CASE 
			WHEN LEN(campaign.name) > 25 THEN SUBSTRING ( campaign.name , 1 , 25 ) + '...'
			ELSE campaign.name
		END,
		CAST(campaign.controlNumber AS int) AS campaignControlNumber,
		allocation.DistributionID,
		allocation.allocationdate,
		Distribution.DistributionNumber,
		SUM(allocationCampaign.allocatedAmount) AS distributionAmount
	from 
		pledgenet.Allocation Allocation,
		pledgenet.allocationCampaign allocationCampaign,
		pledgenet.Distribution Distribution,
		pledgenet.campaign campaign
	WHERE 
		Allocation.YearID = @YearID
	AND 
		Allocation.FederationID = @FederationID
	)
	
	AND
        campaign.stateID =@StateID	
	GROUP BY 
		campaign.campaignID,
		CASE 
			WHEN LEN(campaign.name) > 25 THEN SUBSTRING ( campaign.name , 1 , 25 ) + '...'
			ELSE campaign.name
		END,
		CAST(campaign.controlNumber AS int),
		allocation.DistributionID,
		allocation.allocationdate,
		Distribution.DistributionNumber	
 RETURN 
END

[edit]SHOUTING removed - OriginalGriff[/edit]