ODBC API and Scalar Functions : Scalar Functions : String Functions

String Functions
The following table lists the string functions that ODBC supports.
The string functions listed accept the following arguments:
string_exp can be the name of a column, a string literal, or the result of another scalar function, where the underlying data type is SQL_CHAR, SQL_VARCHAR, or SQL_LONGVARCHAR.
start, length, and count can be the result of another scalar function or a literal numeric value, where the underlying data type is SQL_TINYINT, SQL_SMALLINT, or SQL_INTEGER.
The string functions are one-based; that is, the first character in the string is character 1.
Character string literals must be surrounded in single quotation marks.
ASCII(string_exp)
BIT_LENGTH(string_exp)
CHAR(code)
The character with the ASCII code value specified by code. code should be between 0 and 255; otherwise, the return value is data-source dependent.
CHAR_LENGTH(string_exp)
CHARACTER_LENGTH(string_exp) [ODBC 3.0 only]
CONCAT(string_exp1, string_exp2)
The string resulting from concatenating string_exp2 and string_exp1. The string is system dependent.
DIFFERENCE(string_exp1, string_exp2)
INSERT(string_exp1, start, length, string_exp2)
A string where length characters have been deleted from string_exp1 beginning at start and where string_exp2 has been inserted into string_exp beginning at start.
LCASE(string_exp)
Uppercase characters in string_exp converted to lowercase.
LEFT(string_exp,count)
The count of characters of string_exp.
LENGTH(string_exp)
The number of characters in string_exp, excluding trailing blanks and the string termination character.
LOCATE(string_exp1, string_exp2[,start])
The starting position of the first occurrence of string_exp1 within string_exp2. If start is not specified, the search begins with the first character position in string_exp2. If start is specified, the search begins with the character position indicated by the value of start. The first character position in string_exp2 is indicated by the value 1. If string_exp1 is not found, 0 is returned.
LTRIM(string_exp)
The characters of string_exp with leading blanks removed.
OCTET_LENGTH(string_exp)
POSITION(character_exp IN character_exp)
REPEAT(string_exp, count)
A string composed of string_exp repeated count times.
REPLACE(string_exp1, string_exp2, string_exp3)
Replaces all occurrences of string_exp2 in string_exp1 with string_exp3.
RIGHT(string_exp, count)
The rightmost count of characters in string_exp.
RTRIM(string_exp)
The characters of string_exp with trailing blanks removed.
SOUNDEX(string_exp)
SPACE(count)
SUBSTRING(string_exp, start, length)
A string derived from string_exp beginning at the character position start for length characters.
UCASE(string_exp)
Lowercase characters in string_exp converted to uppercase.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.