TurboDB Engine Dokumentation
String Operators and Functions |
Top |
< | less
|
<= | less or equal
|
= | equal
|
>= | greater or equal
|
> | greater
|
less | less
|
equal | equal
|
greater | greater
|
<> | not equal
|
like | case insensitive correspondence to mask containing jokers, e.g. 'Smith' like 'sMIth', 'Smith' like 'Sm*', 'Smith' like 'Smit?' (all true)
|
Asc(c: Character): Double | Returns the ordinal value of a character.
|
Chr(n: Double): Character | Returns the character for a specified ASCII value.
|
Exchange(Source, From, To: String): String | Replaces all occurrences of From in Source by To and returns the modified string.
|
FillStr(Source, Filler: String; Len: Double): String | Fills the Source with the Filler up to the given Length and returns the result.
|
LeftStr(Source: String; Len: Double): String | Return the left substring of source with given length.
|
Length(Source: String) | Return the count of characters in Source.
|
Lower(Source: String): String | Returns the string in lowercase.
|
LTrim(Source: String): String | Returns Source without any leading white-space.
|
MemoStr(Memo: MemoField): String | Returns the first 255 characters of the content of the memo field in the current record.
|
NTimes(Source: String; Count: Double): String | Returns a string that repeats Source Count times.
|
Pos(SubStr, Source: String): String | Returns the position of SubStr in Source or 0, if SubStr is not contained in Str.
|
RightStr(Source: String; Len: Double): String | Returns the Len last characters of Source.
|
RTrim(Source: String): String | Returns Source without any trailing white-spaces.
|
Scan(SubStr, Source: String): Double | Returns the Double of occurrences of SubStr in Str.
|
Str(Num: Double[; Width, Precision: Double]): String | Returns 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): Real | Calculates 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.
|