[sqlite] Does Substr() use index?

[Paul Gaspar]

Hello, just a short question: Does this use the index on f

   select * from t where SUBSTR(f,1,1) = 'a'

so that it is an alternative for

   select * from t where ( f >= 'a' and f < 'b' )


Thanks a lot

Paul