Jan, could you try: WHERE InvoiceID = .vInvoiceID AND (CTXT(WorkOrderEventID)) LIKE '1012%'
I think that would work. To be honest, I can't imagine that your previous statement worked, given the type mismatch, even in older versions of RB. Anyway, hope this helps. My $0.02, Steve in Memphis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Monday, March 31, 2008 11:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - LIKE Hello group, This is the first time we have run a certain process since upgrading to V8. I'm getting the following error LIKE clause only accepts constant with TEXT or NOTE (2442) I believe it is happening on the following line COMPUTE vTotalInvoice AS SUM WorkOrderCharge FROM InvoiceDetail WHERE + InvoiceID = .vInvoiceID AND WorkOrderEventID LIKE '1012%' WorkOrderEventID is Type INTEGER but this process has worked in the past. I'm going to the clause to an IN to see if it works any better. Jan
