LEFT(string, int)

Parameters

• string - an argument.
• int - a number of characters to extract.

Description

Returns the leftmost number of characters.

Examples

Get 3 first letters of Players' names:

SELECT LEFT(NAME, 3) FROM Players;