Many is set to %
-----Original Message----- From: [EMAIL PROTECTED] To: [email protected] (RBASE-L Mailing List) Date: Mon, 31 Mar 2008 12:25:49 -0400 Subject: [RBASE-L] - Re: LIKE Jan, Have you checked your MANY setting? Dawn Hast "jan johansen" <[EMAIL PROTECTED]> wrote on 03/31/2008 12:22:52 PM: > 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
