Replacement for Left command in SQLite SQL

I have the following query that works fine in MS Access, MySQL and MS SQL but when I try to use it in SQLite I get an error: near "(": syntax error:

I can't find the Left command in any documentation of SQLite so I guess it isn't there but how could I get it to work then.

SELECT Left(fldcall,3) AS Group1, Mid(fldcall,4,1) AS Group2, tblcalls.*, tblzip.fldcity
FROM tblcalls LEFT JOIN tblzip ON tblcalls.fldzipcode = tblzip.fldzipcode;