pfaut is correct. LEFT() basically does the same thing as substr (without offset and replacement options).

LEFT( string, length )
[download]