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 < jasuarezh%40yahoo.es">jasuarezhyahoo.es> wrote:

> Hello,
&gt;
> I have a problem, I need to create a query with a condition OR, in this
>; condition have a comparison with Like.
&gt;
> 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]

Messages in this topic (7) Reply (via web post) | Start a new topic

.