ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-22
String Functions
LTRIM
The LTRIM function returns the characters of string-expression with any leading
blanks removed. For example:
SELECT * FROM employee WHERE { fn LTRIM(last_name) } = "Wang"
RTRIM
The RTRIM function returns the characters of string-expression with any trailing
blanks removed. See LTRIM for an example.
SUBSTRING
The SUBSTRING function returns a character string from string-expression
beginning with start for length characters. For example:
SELECT * FROM employee
WHERE { fn SUBSTRING(first_name,1,4) } = "Bill"
UCASE
The UCASE function returns string-expression shifted to uppercase letters. For
example:
SELECT * FROM employee
WHERE { fn UCASE(last_name) } = "SMITH"
System Functions
The NonStop ODBC Server supports the following CORE SQL system functions:
•
DATABASE
•
USER
DATABASE
The DATABASE function has the following syntax:
LTRIM ( string-expression )
RTRIM ( string-expression )
SUBSTRING ( string-expression, start, length )
UCASE ( string-expression )
DATABASE ( )