The MID function returns the characters of the source_string starting at the start position (numbered from one) up to the specified length. If no length is specified, the rest of the source_string (after the start position) is returned.
The MID function has the following format:
MID(source_string, start[,length])
The MID function accepts the following parameters:
source_string (string)
start (number)
length (number) (Optional)
The MID function returns a string.
Return_value=MID('JuanJuan', 2, 3)
Return_value='uan'
Return_value=MID('JuanJuan', 2)
Return_value='uanJuan'
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |