Problem with replace function

#1

Hi,

Please find the below scenario

Original Table

course branch_exist
BY 0
UI 1
PO 1
LI 0
MK 1

select REPLACE(branch_exist,1,'yes') as branch from university;

displays

course branch_exist
BY 0
UI Yes
PO Yes
LI 0
MK Yes

What i need is

course branch_exist
BY No
UI Yes
PO Yes
LI No
MK Yes

Sql-Server replace function only accepts three arguments, any
suggestions will be greatly welcomed!

#2

Quote:

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/

#3

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/

#4

On Apr 9, 5:37 pm, "kb" <a... (AT) kbupdate (DOT) info> wrote:

Quote:

Oops, typo happens. Right version is:

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

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

Hi Kb,

Thanks you !

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problem with replace function

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Problem with replace function - 04-09-2007 , 07:02 AM

Re: Problem with replace function - 04-09-2007 , 07:34 AM

Re: Problem with replace function - 04-09-2007 , 07:37 AM

Re: Problem with replace function - 04-09-2007 , 08:22 AM