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

> What i need is:
> course branch_exist
> BY No
> UI Yes
> PO Yes
> LI No
> MK Yes

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

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

[Back to original message]