BUG: SELECT with CASE Can Cause Parser Error 403

ID: 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 : SSrvProg
Version : 6.00
Platform : WINDOWS
Issue type :