Posted by meendar on 04/09/07 12:02

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!

• Next in forum: Re: Problem with replace function
• Prev in forum: Help needed for datediff function for SQL query
• Thread view: Problem with replace function

[Reply to this message]