BUG: SELECT with CASE Can Cause Parser Error 403

Q151681

The information in this article applies to:

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


Last Reviewed: March 29, 1999
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.