sql where first letter
SELECT author FROM lyrics WHERE author LIKE 'B%';
Source: stackoverflow.com
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
Source: stackoverflow.com