Steve, That worked! I do know that as R:Base matures there are some items that get 'tightened up'. This may have been one of them. The help file states 'True if a column value equals the text string. With LIKE, a string can also be a DATE,TIME, or DATETIME value. The text string can contain R:BASE wildcard characters.' So it seems funny (at least to me) that DATES would work in a LIKE but an INTEGER would not. It does clearly state TEXT though.
Thanks for the clue. Jan -----Original Message----- From: "Wills, Steve" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 31 Mar 2008 11:38:40 -0500 Subject: [RBASE-L] - RE: LIKE 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
