>>This error message means you can not use Text type for = operator. You need to use varchar(max) or nvarchar(max) to avoid all TEXT type related problems.
>
>So, using VarChar(10) wouldn't work. And, when using VarChar(MAX), this increases the size of the database. We have seen an example on this site. In order to support multilanguage, I had to switch to that type. This has tripled the size of the database. So, no matter the ratio of increase, it will increase by a certain percentage when using that type because it allows a greater support. But, in my case, I do not use that additional support. So, this means, we cannot search for an exact match using VarChar(10) and I do not want to switch to VarChar(MAX) to have that support because of the down benefit I would obtain. So, the question is should I remain with Char(10) instead, which would then allocate more space, even if the record contains an empty value for that field. That is a good question isn't it?

Somewhere there is a serious miscommunication here.

Can you show us a definition of a table you are working with and a code example that is giving you an error? I think this would help everyone wrap their heads around the problem.