$left(text,N) returns the Nth character AND all the characters preceeding it, making it different from this identifier or $mid