Select First two Character in selected Field with Left(string,Number of Char in int) SELECT LEFT(FName, 2) AS FirstName FROM dbo.NameMaster