LEFT

Extracts the left hand part of a string.

Syntax

string LEFT(string value, int num)

Example

LEFT("Account",2)

Will return "Ac"

Another example could be to get the first 4 letters of a product name from the ProductName column, to create a short product name. In this example we will use the following two products "Data Synchronisation Studio" and "Ouvvi":

LEFT(ProductName, 4)

Will return "Data" for the product "Data Synchronisation Studio" and "Ouvv" for the Ouvvi product.