sql server code for find name start with a character WITHOUT using like

Select * from TableName where Left(ColumnName,1) in ('A')