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/

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

[Reply to this message]