>But SET COLLATE TO 'MACHINE' makes my indexes case sensitive. That's what I am trying to avoid. I will have to use UPPER or LOWER functions in index expressions all over the place.
>
>Dmitriy
Sorry, misunderstood the question. The documentation doesn't mention that the collation sequence impacts the result set. It does mention that both SET ANSI and SET EXACT do. However, if you use the UPPER() function on both sides of the LIKE (ie. ...WHERE UPPER(FIELDNAME) LIKE UPPER(cExpr)...), I think you'll get the results you're looking for.
George
Ubi caritas et amor, deus ibi est