Like Expression is also a Boolean Expression, which can be combined with other Boolean Expressions. The following two queries are equal in function:
|
SelectQuery qryCustomer1
= OQL .SelectFrom(NW.Customer) .Where(NW.Customer.ContactTitle.Like("Sales%")); SelectQuery qryCustomer2
= OQL .SelectFrom(NW.Customer) .Where(NW.Customer.ContactTitle % "Sales%"); |
|
The SQL statements generated as follows (taking SQL Server as an example) |
|
SELECT [Customers].* FROM [Customers] WHERE [Customers].[ContactTitle] LIKE 'Sales%' |
Related Topics