Filtering with MS SQL uses standard SQL WHERE clause syntax. MS SQL (Microsoft SQL Server) supports a rich set of operators, functions, and data types for flexible querying.
'text value'[Field Name]AND and OR operators'YYYY-MM-DD' or 'YYYY-MM-DD HH:MM:SS'| Field Name | Filter |
| CustomerID | CustomerID = 'CUST001' |
| Name | Name = 'Acme Corporation' |
| Order Status | [Order Status] = 'Completed' |
| Description | Description LIKE '%bicycle%' |
| ProductCode | ProductCode LIKE 'PROD-%' |
| Email LIKE '%@example.com' | |
| Comments | Comments IS NULL |
| ShipDate | ShipDate IS NOT NULL |
| Notes | Notes = '' |
| ItemNumber | ItemNumber != '' |
| Amount | Amount > 1000 |
| ModifiedDate | ModifiedDate >= DATEADD(day, -7, GETDATE()) |
| Status | Status IN ('Active', 'Pending', 'Processing') |
| CustomerID | CustomerID NOT IN ('', 'CUST999', 'TEST001') |
| Status | Status = 'Active' AND Amount > 500 |
| Product Type | [Product Type] = 'Hardware' OR [Product Type] = 'Software' |
| OrderDate | OrderDate >= '2025-01-01' |
| OrderID | OrderID IN (SELECT OrderID FROM Orders WHERE OrderDate >= '2025-01-01' AND CustomerID NOT IN ('', 'CUST001', 'CUST002')) |
[Field Name] when the field name contains spaces or special characters.'value'.'YYYY-MM-DD' or 'YYYY-MM-DD HH:MM:SS' for dates.IS NULL for NULL checks, use = '' for empty strings.% matches any sequence of characters, _ matches a single character.% is a wildcard (not * like in NAV)