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]
