i have a table(employee) with a field(ename), i want to get list of employees whose name starts with the letter 'a' and not 'A', how can i perform this.

eg:

ambrose
antony
Abraham
amar
Anand

the query must return only the names (ambrose,antony,amar) and not (Abraham,Anand).

try to explain with sample sql query.

thanks for your coordination.