Re: "MATCHES A*" within a query

In article <01bd28ad$d0994200$b82c70c2@jet>, tan <tan@jettech.dircon.co.uk> writes >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 > It will use an index if there is one on 'field'. The only problem comes with select {various fields} where {field} MATCHES "*A" i.e. where the first character is anything. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care