Posted by kb on 04/09/07 12:37

Oops, typo happens. Right version is:

select
CASE branch_exist
WHEN 1 THEN 'yes'
WHEN 0 THEN 'no'
ELSE '?'
END as branch
from university;


--
Tom
http://kbupdate.info/ | http://suppline.com/

[Back to original message]