Home > Blog > Using Like in X++

Using Like in X++

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;

Our Verified Expert

Becky Newell

Becky is a co-founder of Stoneridge Software and the President of Levridge, a subsidiary of Stoneridge Software. She has expertise in X++, .NET, Enterprise Portal, and reporting development. She is a 14-year veteran of Microsoft, where she provided support to partners and ISV development teams. She has trained many development teams and is a consistent trainer at Microsoft's Fast TrAX Academy, AX user groups and Stoneridge online training courses.

Read More from Becky Newell

Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.

Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.