<div>
UPDATE dbo.Schools &nbsp;SET SchoolType = 'Denom' &nbsp;WHERE SchoolType = 'D'<br />
UPDATE dbo.Schools &nbsp;SET SchoolType = 'Non-Denom' &nbsp;WHERE SchoolType = 'N'
</div>


UPDATE dbo.Schools  SET SchoolType = 'Denom'  WHERE SchoolType = 'D'
UPDATE dbo.Schools  SET SchoolType = 'Non-Denom'  WHERE SchoolType = 'N'

<div>
Thanks for the reply but i need them in select statement
</div>


Thanks for the reply but i need them in select statement

<div>
Please try this<br />
<br />

<pre><code id="code-602692">
if SchoolType contains only 'N' and 'D', then you can proceed with (1) query otherwise (2)

1) select if(schooltype='D','Denom','Non-Denom') from tablename

2) select if(schooltype='D','Denom',if(schooltype = 'N','Non-Denom',schooltype)) from tablename;
</code></pre>
</div>


Please try this




if SchoolType contains only 'N' and 'D', then you can proceed with (1) query otherwise (2)

1) select if(schooltype='D','Denom','Non-Denom') from tablename

2) select if(schooltype='D','Denom',if(schooltype = 'N','Non-Denom',schooltype)) from tablename;


<div>
<div class="content wysiwyg-content">
I have a column in the database called SchoolType with the possible values N and D. I want to repalce N with Non-Denom and D with Denom. I have tried something like this in sql <br />
<br />
select distinct replace (replace (SchoolType,'D', 'Denom') ,'N','Non-Denom') from dbo.Schools where Schooltype is not null<br />
<br />
the results lI get are like <br />
<br />
DeNon-Denomom<br />
Non-Denom<br />
<br />
how could we achive the desired results? as below<br />
<br />
Denom <br />
Non-Denom<br />

</div>
</div>


I have a column in the database called SchoolType with the possible values N and D. I want to repalce N with Non-Denom and D with Denom. I have tried something like this in sql 

select distinct replace (replace (SchoolType,'D', 'Denom') ,'N','Non-Denom') from dbo.Schools where Schooltype is not null

the results lI get are like 

DeNon-Denomom
Non-Denom

how could we achive the desired results? as below

Denom 
Non-Denom


how to do multiple Replace in one column in sql statement

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.