Hi Michael,

>I'm thinking that the problem is the ucase() of the text column. Hmmm...The BOL says that SQL Server will do an implicit conversion between Text and Varchar.
>
>If your SQL Server is installed with a case-insensitive sort order (the default) then you don't need the ucase(). Try that.
>

After some testing, it turns out that you are right.

This presents a problem for us, since the application is to front-end a variety of back-ends. e.g. the customer could have SQL Server, Oracle or even VFP on the backend.

I guess we'll have to tailor the query to the back-end.

Best.

Matt.