The LEFT function returns a specified number of characters of a string. If the string is shorter than the specified number of characters, the entire string is returned.
The LEFT function has the following format:
LEFT(source_string, length)
The LEFT function accepts the following parameters:
source_string (string)
length (number)
The LEFT function returns a string.
Return_value=LEFT('JuanJuan', 2)
Return_value='Ju'
Return_value=LEFT('JuanJuan', 10)
Return_value=('JuanJuan')
Return_value=LEFT('JuanJuan', 0)
Return_value=''
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |