String matching

Is there a way to use indexes for queries like:

select field from table where field like 'abc%'

(i.e. filter for string fields that begin with something) ?