Using ‘Not Like’ in Ax X++

  • October 13, 2009
  • 0 Comments

When you want to use wild-cards in Ax, you can write a SQL statement with a LIKE keyword 1 2 select firstonly purchTable where purchTable.purchId like ’09*’;select firstonly purchTable where purchTable.purchId like ’09*’; When you want to have all the other records (not like), in X++ SQL-statements you have 3 possibilities: 1.!LIKE : 1 2 … Continue Reading