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