Hi, u can write in this way ....
select table1 where ( table1.campo1 like '*xxxx*' || table1.campo2 like '*yyyy*' ) ________________________________ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jasuarezh Sent: Thursday, July 03, 2008 11:02 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Query sentence or and Like 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]