What would be the correct function syntax to use if I want to populate a field on a MySQL table with the three first character of the row on a Excel spread sheet.
I'm using ODBC to connect to MySQL table.
As shown on the image below I tried using the function "SubString([PHONE],1,3):[PHONE]" but it does not seem to work in neither Mapping Type (Calculate or SQL Statement).
I will appreciate your assistance on this matter.
Thanks
Robert