Concatenation Operator


Description: Concatenates (joins) strings and substrings together into a target unit. Use the plus operator to add string variables, literals or any combination thereof.

Symbol: +

Example: If Field FName contained John and Field LName contained Smith, then Mr.+LName would result in Mr.Smith and FName+ LName would result in John Smith.

Placement: See Addition.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*