SELECT Comment FROM #Request.prefix_db_agency#.Invoices WHERE Invoice_ID = '#InvoiceID#' update #Request.prefix_db_agency#.Invoices set Comment = '#message#' ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Invoice_ID = '#InvoiceID#'