Using Like in X++

By Becky Newell | March 16, 2013

In SQL it is common to use like when querying data.  For example, the following SQL statement queries the CustTable table for all customers that begin with '12':

select * from CustTable where AccountNum like '12%'

It is also possible to use like in X++ syntax.  The following X++ statement queries the CustTable table for the same data:

CustTable custTable;
AccountNum accountNumFilter;
accountNumFilter = '12*';
select custTable where custTable.AccountNum like accountNumFilter;

Related Posts

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!