SQL String Functions

SQL String Functions

String	Description
Asc	Returns a number representing the character code of the first character in string.
Chr	Returns a one character string containing the character whose character code is number. Number must be in the range 0-255, or a run-time error will occur.
Instr	Returns the position of one string within another string, from the start of the string.
InstrRev	Returns the position of one string within another string, from the end of the string.
Left	Returns the leftmost characters of a string, of a selected length.
Length	Returns the length of string.
Lower	Returns a string in lower case.
LPad	Left pad string to a specified number of characters.
Mid	Returns a sub-string of a string.
Occurs	Returns the number of occurrences of a string within another string.
PadAcctNo	Creates a bank account number from a Bank Account string and a Pattern string, using a Pad Character.
Position	Returns the position of a substring in a string.
Proper	Returns a string in proper case.
Replace	Replaces a specified substring with another substring.
Right	Returns the rightmost characters of a string, of a selected length.
RPad	Right pad string to a specified number of characters.
Substring	Returns a sub-string of a string.
Trim	Removes leading and trailing spaces from a string.
Upper	Returns a string in upper case.
WordAmount	Returns string with an amount in words.

In This Section

Asc - SQL Function

Chr - SQL Function

Instr - SQL Function

InstrRev - SQL Function

Left - SQL Function

Length - SQL Function

Lower - SQL Function

LPad - SQL Function

Mid - SQL Function

Occurs - SQL Function

PadAcctNo - SQL Function

Position - SQL Function

Proper - SQL Function

Replace - SQL Function

Right - SQL Function

RPad - SQL Function

Substring - SQL Function

Trim - SQL Function

Upper - SQL Function

WordAmount - SQL Function

SQL User Functions