I got the following error on the first line and I'm not sure why. The appropriate fields in both tables (oas_balance and oas_testit) have the same data-types. Could it be an out of order thing? ERROR: Implicit conversion from data type varchar to money is not allowed. Use the CONVERT function to run this query. SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1, oas_balance.el2, oas_balance.full_value, CASE WHEN balcode = 'ACTUAL' AND yr = '2008' And period = '6' AND IsNull(full_value, '') = '' THEN 0 ELSE full_value END AS Act_Amt, CASE WHEN balcode ='BUDGET' AND yr = '2008' And period ='6' AND IsNull(full_value, '') = '' THEN 0 ELSE full_value END AS Bud_Amt, CASE WHEN balcode ='ACTUAL' AND yr = '2008' - 1 And period = '6' AND IsNull(full_value, '') = '' THEN 0 ELSE full_value END AS LY_Amt, CASE WHEN balcode ='ACTUAL' AND period <= '6' And yr = '2008' AND IsNull(full_value, '') = '' THEN 0 ELSE full_value END AS ActYtd_Amt, CASE WHEN balcode ='BUDGET' AND period <= '6' And yr = '2008' AND IsNull(full_value, '') = '' THEN 0 ELSE full_value END AS BudYTD_Amt, CASE WHEN balcode ='ACTUAL' AND period <='6' And yr ='2008'-1 AND IsNull(full_value, '') = '' THEN 0 ELSE full_value END AS LYYTD_Amt, oas_balance.balcode, oas_balance.yr, oas_balance.period, oas_balance.repbasis INTO oas_testit FROM oas_balance WHERE oas_balance.cmpcode ="FORNAIO" AND oas_balance.el1 >"39999" AND (oas_balance.balcode ="ACTUAL" Or oas_balance.balcode ="BUDGET") AND (oas_balance.yr = '2008' Or oas_balance.yr = '2008'-1) AND oas_balance.period <='6' AND oas_balance.repbasis ='3';