Microsoft KB Archive/151681

{|
 * width="100%"|

BUG: SELECT with CASE Can Cause Parser Error 403

 * }

Q151681

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
A SELECT statement against multiple tables that includes a CASE expression can result in parser error 403:

Invalid operator for datatype op: UNKNOWN TOKEN type: char

To reproduce this problem, the tables should have at least two columns of datatype CHAR, and three tables must be involved in the SELECT statement. Also, a join must be specified between two of these tables.

WORKAROUND
Avoid using the CASE expression by rewriting the query using the IF..ELSE conditional Transact-SQL statement.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords :

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600