You are here

Neuen Kommentar schreiben

Text and Strings

Here you find most important text and string functions, which are supported by most of the sql database systems.

SyntaxDescription
LENGTH(Formula) Returns the length of the string in characters
LEFT( Formula1 , Formula2 ) Returns a number of characters, specifyed by Fomula2, from the left side of the argument Formula1.
RIGHT(Formula1, Formula2) Returns a number of characters, specifyed by Fomula2, from the right side of the argument Formula1.
SUBSTR(Formula1, Formula2, Formula3) Returns a substring from the argument Formula1, which starts at position Formula2 and is Formula3 characters long.
TRIM(Formula) TRIM deletes all spaces form the left and right sides of the argument.
VALUE(Formula) DB2. Converts the string into a numeric value.