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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only