ComponentOne DataObjects for .NET
Escaping Special Characters and Reserved Words
DataObjects for .NET (Enterprise Edition) > Features and Techniques > DataObjects for .NET Expressions > Escaping Special Characters and Reserved Words

Variable (field) names must be enclosed in square brackets if they include blanks or any of the following special characters, or coincide (ignoring case) with a reserved word.

Special characters: \n (newline) \t (tab) \r (carriage return) ~ ( ) # \ / = > < + - * % & | ^ ' " [ ]

Reserved words: CHILD, PARENT, CURRENT, ORIGINAL, BEFORECHANGE, IN, LIKE, AND, OR, NOT, CONVERT, LEN, ISNULL, IIF, SUBSTRING.

Examples of escaped field name: [Order Date], [CustomerID#]

If a field name contains closing bracket, it must be escaped with \. For example, field name Customer[Name] is written as [Customer[Name\]].