User-defined values may be used within expressions to be compared with column values. String values should be enclosed within single quotation marks (and each single quotation character in a string value has to be escaped by prepending it with another single quotation character). Date values should be enclosed within pound signs (#) or single quotes (') based on the data provider. Decimals and scientific notation are permissible for numeric values. For example:
FirstName = 'John'
Price <= 50.00
Birthdate < #1/31/82#
For columns that contain enumeration values, cast the value to an integer data type. For example:
EnumColumn = 5
Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.