Hi, I think a lot of people have already asked this question, you should browse this forum.
I give you the example code: qbr = this.query().datasourcetable(tablenum(custTable)).addrange(fieldnum(custtable, recid)); range = strfmt('((%1 == \"%2\") || (%3 == \"%4\"))', fieldstr(CustTable,Name),name, fieldstr(CustTable,InvoiceAccount),account); qbr.value(range); Cheers, David S On Thu, Jul 3, 2008 at 6:01 PM, jasuarezh <[EMAIL PROTECTED]> wrote: > Hello, > > I have a problem, I need to create a query with a condition OR, in this > condition have a comparison with Like. > > My query in SQL is: > > select * from TABLA1 where TABLA1.campo1 like '%xxxx%' || TABLA1.campo2 > like '%yyyy%' > > How I do in Axapta this query??? > Thanks you very much > > > [Non-text portions of this message have been removed]