Re: Using the MATCHES keyword (but outside a WHERE clause)

From my understanding, Informix SQL keyword "MATCHES" is case sensitive. That is, you can use "ISTA" to match "ISTA" or "VISTA", but not "Ista" nor "ista". How can I make it match or partially match fields of different case in SQL? Thanks, Allen Email: agu@ai.org