![LEAD function [Analytical]](arrow-left.gif){kind=icon}
![LEN function [String]](arrow-right.gif){kind=icon}
Returns a specified number of characters from the beginning of a string.
LEFT ( string-expression, numeric-expression )
numeric-expression The number of characters to return.
The following statement returns the value “choco”:
SELECT LEFT( 'chocolate', 5 ) FROM iq_dummy
If the string contains multibyte characters, and the proper collation is being used, the number of bytes returned may be greater than the specified number of characters.
The
result data type of a LEFT function is a LONG
VARCHAR. If you use LEFT in a SELECT
INTO statement, you must have an Unstructured Data Analytics
option license or use CAST and set LEFT to
the correct data type and size.
See “REPLACE function [String]” for more information.
Chapter 11, “International Languages and Character Sets” in the System Administration Guide: Volume 1
