"MATCHES A*" within a query

If I have a select statement in the form: select {various fields} where {field} MATCHES "A*" Will this query utilise an index or do I have to get rid of the "MATCHES" clause and then use something like perl to actually extract my data? Thanks Tan