![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Mon, 22 Oct 2001 @ 21:27:54 GMT
Subj: | | Re: SQL Question (see red line below) |
|
From: | | Thomas F. Stanek |
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
| |