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/

• Next in forum: Re: Problem with replace function
• Prev in forum: Problem with replace function
• Thread view: Re: Problem with replace function

[Reply to this message]