String Operators and Functions

Previous  Top  Next


Operators
+   concatenation, e.g. EMPLOYEES.FirstName + ' ' + EMPLOYEES.LastName   
[]   access to single character, e.g. EMPLOYEES.FirstName[1] + '. ' + EMPLOYEES.LastName   

Comparisons
<less     
<=less or equal     
=equal     
>=greater or equal     
>greater     
lessless     
equalequal     
greatergreater     
<>not equal     
likecase insensitive correspondence to mask containing jokers, e.g. 'Smith' like 'sMIth', 'Smith' like 'Sm*', 'Smith' like 'Smit?' (all true)     

Functions
Arguments in brackets are optional.
Asc(c: Character): DoubleReturns the ordinal value of a character.     
Chr(n: Double): CharacterReturns the character for a specified ASCII value.     
Exchange(Source, From, To: String): StringReplaces all occurrences of From in Source by To and returns the modified string.     
FillStr(Source, Filler: String; Len: Double): StringFills the Source with the Filler up to the given Length and returns the result.     
LeftStr(Source: String; Len: Double): StringReturn the left substring of source with given length.     
Length(Source: String)Return the count of characters in Source.     
Lower(Source: String): StringReturns the string in lowercase.     
LTrim(Source: String): StringReturns Source without any leading white-space.     
MemoStr(Memo: MemoField): StringReturns the first 255 characters of the content of the memo field in the current record.     
NTimes(Source: String; Count: Double): StringReturns a string that repeats Source Count times.     
Pos(SubStr, Source: String): StringReturns the position of SubStr in Source or 0, if SubStr is not contained in Str.     
RightStr(Source: String; Len: Double): StringReturns the Len last characters of Source.     
RTrim(Source: String): StringReturns Source without any trailing white-spaces.     
Scan(SubStr, Source: String): DoubleReturns the Double of occurrences of SubStr in Str.     
Str(Num: Double[; Width, Precision: Double]): StringReturns the alphanumeric representation of Num with given Width and Precision. Width=1 means as needed. The alphanumeric representation of an enumeration value (see column data types) is the name of the value.     
Val(Expression: String): RealCalculates the numeric value of an string expression. Use Val to convert a number string to the corresponding numeric value. The number string can be a float, a date, a time or an enumeration literal.