The LEFT function returns a length number of characters from the leftmost of string. If any of the arguments is NULL, NULL is returned. If a value greater than the length of the string or a negative number is specified for a length, the entire string is returned.
To extract a length number of characters from the rightmost of the string, use the RIGHT Function.
LEFT( string , length )
string :
• character string
• NULL
length :
• INT
• NULL
SELECT LEFT('CUBRID', 3);
left('CUBRID', 3)
======================
'CUB'
SELECT LEFT('CUBRID', 10);
left('CUBRID', 10)
======================
'CUBRID'