Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
String Functions
Previous  Top  Next



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  

        © 2003 - 2017 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Oct 23, 2017