LEFT Function -- Syntax and Examples

LEFT(string, length[, pad])

left("Truncated string",5)

returns the value "Trunc"

left("Extended string",20,".")

returns the value "Extended string....."

LeftVal = left("Truncated string",5,".")

assigns the value "Trunc" to the variable LeftVal

Next