left

Retrieve the leftmost characters from a string

Syntax

left(string_expr,num)

Arguments

string_expr	A string expression.
num	The number of the leftmost characters of strexp to be returned.

Description

This scalar string function retrieves the specified number of characters from the leftmost part of a string. The string can be an ASCII string or a Unicode string. If a Unicode string is specified, the function returns a Unicode string.