create table value Function in SQL Server

Create FUNCTION [dbo].[MobileIntelligenceLoadMIL]
(
  @ExpenseId AS VARCHAR(50)='',
  @Attendee_FullName AS VARCHAR(100)=''
)
RETURNS @retMobileIntelligenceInformation TABLE
(
 Individual_Amount DECIMAL(18,2)
)
AS
BEGIN
    DECLARE
 @Individual_Amount Decimal
 --SELECT @Individual_Amount = (Expense_Amount/Total_Attendees) FROM  PMP_ExpenseStaging
 --WHERE Expense_Id = @ExpenseId AND Full_Name = @Attendee_FullName AND Convert(VARCHAR(10), CMDate,121) = Convert(VARCHAR(10),GetDate(),121)

 SELECT @Individual_Amount = (Expense_Amount/Total_Attendees) FROM PMP_ExpenseStaging
 WHERE Expense_Id = @ExpenseId
 AND Full_Name = @Attendee_FullName
 AND Convert(VARCHAR(10), CMDate,111) = Convert(VARCHAR(10),GetDate(),111)

 INSERT @retMobileIntelligenceInformation
 SELECT @Individual_Amount AS Individual_Amount
 FROM PMP_ExpenseStaging
 WHERE Expense_Id = @ExpenseId
 AND LTRIM(RTRIM(Full_Name)) = LTRIM(RTRIM(@Attendee_FullName))
 AND Convert(VARCHAR(10), CMDate,111) = Convert(VARCHAR(10),GetDate(),111)
 RETURN;
END