Archives of the TeradataForum

Message Posted: Mon, 22 Oct 2001 @ 21:27:54 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Tony,

I've used the approach mentioned by Yonina with success before. What error message are you getting? Is it possible that the zero value in the ELSE portion if the case statement is actually the letter 'O'? Otherwise, the following syntax should work:

SELECT CASE WHEN TABLEKIND EQ 'V'
            THEN 1
            ELSE 0
            END     (INTEGER) AS TBL_KIND
  FROM DBC.TABLES

Regards,

Thomas F. Stanek
TFS Consulting

	<Prev	Next>		<<First	<Prev	Next>	Last>>