Nested functions are calculated from the inside out.

Commas are not permitted in numeric constants.

Alternative quote characters, such as smart quotes, are not permitted in string constants.

Be careful using null. An empty string (for example "") or a zero value (0) is not the same as null.

Review spacing. The system views spaces as two different attributes. For example, First Name would search for a data field named "First" instead of "First Name."

The lookup function only returns a single value. If the criteria used in the lookup function matches multiple records, the function returns the first found value, regardless if more values exist.

Certain functions are not intended for send time use with high volume. These include EncryptSymmetric,CreateSalesforceObject, and InsertDE functions.