ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.Replace number with word using CASE statement in SQL Server<p>Use case statement.</p> <pre class="brush: sql">SELECT,emp.address, case when emp1.app_status = 1 then &#39;application received&#39; when emp1.app_status = 0 then &#39;not received&#39; end as appstatus FROM table emp inner join table1 emp1 on =</pre> <p>&nbsp;</p>, 13 Jun 2019 00:05:00 GMT