only get first letter of string sql code example

Example 1: sql first character

Select First two Character in selected Field with Left(string,Number of Char in int)

SELECT LEFT(FName, 2) AS FirstName FROM dbo.NameMaster

Example 2: query only first letter string

LEFT(colName, 1)