|
<< Click to Display Table of Contents >> AbsDB SQL String functions |
  
|
AbsDB SQL String functions
|
<< Click to Display Table of Contents >> AbsDB SQL String functions |
|
String Functions
Absolute Database supports the following string functions:
Function |
Description |
LOWER |
Converts string to lower case |
UPPER |
Converts string to upper case |
SUBSTRING |
Extracts substring |
POS |
Location of specified substring |
LENGTH |
Number of characters in string |
LTRIM |
Returns the string with leading space characters removed |
RTRIM |
Returns the string with trailing space characters removed |
TRIM |
Returns the string with leading and trailing space characters removed |
LOWER (string_exp)
Returns a string equal to that in string_exp with all uppercase characters converted to lowercase.
Example:
LOWER('TOM') returns tom
UPPER (string_exp)
Returns a string equal to that in string_exp with all lowercase characters converted to uppercase.
Example:
UPPER('tom') returns TOM
SUBSTRING (string_exp, start [, length])
Returns a character string that is derived from string_exp beginning at the character position specified by start for length characters.
Example:
SUBSTRING("ABCDE", 4, 2) returns DE
POS (substring_exp, string_exp)
Returns the position of the first character expression in the second character expression.
Example:
POSITION('CDE','ABCDEFG') returns 3
LENGTH (string_exp)
Returns the number of characters in string_exp.
Example:
LENGTH('ABCEDFG') returns 7
LTRIM (string_exp)
Returns the characters of string_exp, with leading blanks removed.
Example:
LTRIM(' Tom ') returns 'Tom '
RTRIM (string_exp)
Returns the characters of string_exp, with trailing blanks removed.
Example:
RTRIM(' Tom ') returns ' Tom'
TRIM (string_exp)
Returns the characters of string_exp with leading and trailing space characters removed.
Example:
TRIM(' Tom ') returns 'Tom'
_____________________________
27-10-2017 - Niels Knabe