the newshistory.sql cript under ftp directory /emerald/sql/
Select Date, "Payment", Amount, Description = CASE WHEN CheckNumber = '0' THEN PayInfo ELSE 'Check No: ' + CheckNumber + ' ' + PayInfo END, PaymentID