Arithmetic MODULO operator

SQL Server Query

            
SELECT TOP 100  

    OrderID,  

    ProductID,  

    Quantity,  

    UnitPrice  

FROM [Order Details]  

WHERE ProductID % 2 = 1;  

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

    .Select().Top(100)  

    .Columns("OrderID","ProductID","Quantity","UnitPrice")  

    .From("[Order Details]", "od")  

    .Where(new Where(new ColumnArithmatic("ProductID").MODULO(2).Equale(1)))  

    .Build();  

            
        

Query build by SqlQueryBuilder

            
SELECT TOP 100 OrderID,
               ProductID,
               Quantity,
               UnitPrice
FROM [Order Details] AS od
WHERE ProductID % @pMAIN_2507200128177159580 = @pMAIN_2507200128177159581;


            
        

Parameters (If used)

Query Results: