I have a SQL 2000 Database with a table which contain the following fields and desperately need Help creating the SQL mathematic function. EM_NAME (Employee Name) DOH (Date of Hire) MGP(Monthly Gross Profit) MBS(Employee#%92s Monthly Base Salary) COMM_%(Commission Percentage) COMM_PD(Commission Paid) I need to create the following calculation. If Today's Date ( subtracted ) from the Hire Date is ( > greater than ) than 1 Year . And the Employee generated a total profit ( = equal to or > greater than ) 2.5 times their monthly salary. Then pay the employee the sum of their monthly salary ( x times ) their commission ( % percentage ). ELSE Pat the Employee commission... Any help would be greatly appreciated.