You can apply functions to your query criteria. This allows you to use database-style functions within your query without having to write specific SQL.
Function |
Description |
Example |
---|---|---|
IndexOf |
Will return any results where the index within a value matches your specified value. Can be modified with the operator type as well, such as NotEquals. |
o.Name.IndexOf("ter") = 5 |
ToUpper |
Will make all values in the database upper case, but not the given criteria. |
o.Name.ToUpper() = "UPPERCASENAME" |
ToLower |
Will make all values in the database lower case but not the given criteria. |
o.Name.ToLower() = "lowercasename" |
Length |
Any values where the length of that value matches your given criteria. Can be modified with an operator, such as GreaterThan, LessThan. |
o.Name.Length() <> 3 |
Substring |
Any values where the string between two given locations within the value matches your criteria. Can be modified with an operator, such as Equals, NotEquals. |
o.Name.Substring(3) = "ter" |