>Select * from mytable where ;
>{fn ucase(mymemofield)} ;
>LIKE "'%" + mytextvar +"%'"
>
>I'm not at the office at the moment, so I don't have the precise error message, but it's something to do with trying to convert the data type to VARCHAR.

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.

-Mike