What type of “Expression” can we use with User Defined Columns
| Token | Meaning |
|---|---|
ColumnName | Refer to columns by name. If the column name contains a special character, enclose the name in square brackets. |
50 or 50.0 or 5E1 | Numeric constants can be represented as integers, floating point, or in scientific notation. |
#9/2/1959# | Date constants should be quoted with pound signs. |
'Polygon' | String constants should be quoted with single quotes. |
AND, OR, NOT | Boolean operators |
<, >, <=, >=, <>, =, IN, LIKE | Comparison operators |
+, -, *, /, % | Arithmetic operators |
+ | String concatenation operator |
* or % | Wildcards for string comparison |
Child.ColumnName or Child(RelationName).ColumnName | Column in a child table |
Parent.ColumnName | Column in a parent table |
Sum(), Avg(), Min(), Max(), StDev(), Var() | Aggregate functions |
CONVERT(expression, type) | Convert an expression to a .NET type |
LEN(string) | Length of a string |
ISNULL(expression, replacement) | Returns the expression if it isn’t Null, otherwise returns the replacement |
IIF(expression, truepart, falsepart) | Returns truepart or falsepart depending on whether the expression is true or false |
TRIM(expression) | Removes leading and trailing blanks |
SUBSTRING(expression, start, length) | Returns length number of characters from the specified starting point |
Revised: 2024-08-02
Copied!