Hi, Please try this code : change % with * SELECT * FROM TABLA1 where TABLA1.campo1 like "*xxxxx*" || TABLA1.campo2 like "yyyyy*"
--- 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, 8: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 [Non-text portions of this message have been removed]