Appendix A – Allowed SQL
Copy
This Appendix contains a list of all allowed SQL tokens and functions which can be used in a Where attribute, In condition, or Between condition.
| SQL Token | Comments |
| Add | |
| And | |
| As | |
| Between | |
| Case | |
| Coalesce | |
| Collate | |
| Convert | |
| CurrentDate | See Reserved Keywords (https://msdn.microsoft.com/en-us/library/ms189822.aspx) |
| CurrentTime | See Reserved Keywords (https://msdn.microsoft.com/en-us/library/ms189822.aspx) |
| CurrentTimestamp | See Reserved Keywords (https://msdn.microsoft.com/en-us/library/ms189822.aspx) |
| Double | |
| Else | |
| End | |
| Escape | |
| In | |
| Is | |
| Like | |
| Not | |
| Null | |
| NullIf | |
| Of | |
| On | |
| Or | |
| Some | |
| Then | |
| When | |
| Precision | |
| TryConvert | |
| Bang | Symbol "!” |
| PercentSign | |
| Ampersand | |
| LeftParenthesis | |
| RightParenthesis | |
| LeftCurly | |
| RightCurly | |
| Star | |
| MultiplyEquals | |
| Plus | |
| Comma | |
| Minus | |
| Dot | |
| Divide | |
| Colon | |
| DoubleColon | |
| Semicolon | |
| LessThan | |
| EqualsSign | |
| GreaterThan | |
| Circumflex | |
| VerticalLine | |
| Tilde | |
| AddEquals | |
| SubtractEquals | |
| DivideEquals | |
| ModEquals | |
| BitwiseAndEquals | |
| BitwiseOrEquals | |
| BitwiseXorEquals | |
| Integer | |
| Numeric | |
| Real | |
| HexLiteral | |
| Money | |
| DollarPartition | |
| AsciiStringOrQuotedIdentifier | |
| AsciiStringLiteral | |
| UnicodeStringLiteral | |
| Identifier | |
| QuotedIdentifier | |
| SingleLineComment | |
| MultilineComment | |
| WhiteSpace |
| SQL Function Name | Comments |
| GETDATE | |
| GETUTCDATE |