In reply to Daniel Boisvert.

Both of these work for me. Don't include the WHERE keyword in your filter. That is, use just:

substr(name,1,1)='A'