Label Thematic Map Annotation Expression Guide
Symbol Meaning Supported Engines Example Effect
+ Concatenation operator Supports UDB, SQL data sources

Format: Field1 + Field2 + Field3 + ...

Type: Text, String

Example: NAME + ENAME

  
|| Concatenation operator Supports UDB, UDBX, Oracle data sources

Format: Field1 || Field2 || Field3 ||...

Type: Text, String or Numeric

Example: NAME || GDP_2000

  
[/] Fraction separator Supports UDB, UDBX, Oracle data sources

Format: Field1 [/] Field2

Type: Text, String or Numeric

Example: NAME [/] POP_1990 || '万人'

  
chr(10) Line break Supports UDB, Oracle data sources

Format: Field1 || chr(10) || Field2...

Type: Text, Numeric, String

Example: BaseMap_R.NAME || Chr(10) || BaseMap_R.POP_1999

  
char(10) Line break Supports SQL data sources

Format: Field1 + char(10) + Field2...

Type: Text

Example: NAME + Char(10) + POP_1999

  
chr(45) Separator Supports Oracle data sources

Format: Field1 || chr(45) || Field2...

Type: Text

Example: NAME || Chr(45) || NAME

  
char(45) Separator Supports SQL data sources

Format: Field1 + char(45) + Field2...

Type: Text

Example: NAME + Char(45) + NAME

  
str() Converts numeric values to strings Supports SQL data sources

Format: str(Field)

Type: Text, String or Numeric

Example: NAME + ':' + Str(POPU) + '万人'

  
to_char() Converts numeric values to strings Supports Oracle data sources

Format: to_char(Field)

Type: Text, String or Numeric

Example: NAME [/] 'Area:' || to_char( SMAREA)