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) |
![]() |