Try this:
Void trythis()
{
  TABLA1 cursorTABLA1;
  ;
  select cursorTABLA1 where cursorTABLA1.comp1 like '*xxxx*' || 
cursorTABLA1.compo2 like '*yyyy*'
}

--- On Thu, 7/3/08, jasuarezh <[EMAIL PROTECTED]> wrote:

From: jasuarezh <[EMAIL PROTECTED]>
Subject: [development-axapta] Query sentence or and Like
To: development-axapta@yahoogroups.com
Date: Thursday, July 3, 2008, 1:01 AM






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

 














      

Reply via email to