ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Replace number with word using CASE statement in SQL Server<p>Use case statement.</p> <pre class="brush: sql">SELECT emp.name,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 emp.id = emp1.id</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/461584/Replace-number-with-word-using-CASE-statement-in-SQL-Server/https://www.aspforums.net:443/Threads/461584/Replace-number-with-word-using-CASE-statement-in-SQL-Server/Thu, 13 Jun 2019 00:05:00 GMT