LEFT

Returns the leftmost specified number of characters from the string. The first argument is the string expression. The second argument is the number of characters to return from the left.

Example:

Assume the column NAME has a value of 'KATIE AUSTIN' and FIRSTNAME_LEN (int) has a value of 5.

  LEFT(NAME, FIRSTNAME_LEN)

Returns the value 'KATIE'