<div>
Everyone, all of these were right on... I had the syntax incorrect. &nbsp;I going to split up the points as everyone provided great info.
</div>


Everyone, all of these were right on... I had the syntax incorrect.  I going to split up the points as everyone provided great info.

<div>
Awarded Aneesh half of the 500 as they were the first one to respond.
</div>


Awarded Aneesh half of the 500 as they were the first one to respond.

<div>
<div class="content wysiwyg-content">
This should be simple... How to specify a column name &quot;as .....&quot; when using a case statement (in bold below).<br />
<br />
COALESCE(T1.POSTCODE_FW, '') as 'Zip Code',<br />
COALESCE(T1.VENDOR_SPECIAL<wbr />TY_FW, '') as 'Vendor Specialty',<br />
COALESCE(T1.VENDOR_TYPE_FW<wbr />, '') as 'Vendor Type',<br />
<br />
<b>CASE <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHEN T1.SUPSTATUS_FW = '0' THEN ''<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHEN T1.SUPSTATUS_FW = '1' THEN 'YES'<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ELSE ''<br />
END,</b><br />
<br />
COALESCE(CONVERT(varchar(1<wbr />0), T2.START_DATE_FW, 101), '') as 'Start Date',<br />
COALESCE(CONVERT(varchar(1<wbr />0), T2.END_DATE_FW, 101), '') as 'End Date',
</div>
</div>


This should be simple... How to specify a column name "as ....." when using a case statement (in bold below).

COALESCE(T1.POSTCODE_FW, '') as 'Zip Code',
COALESCE(T1.VENDOR_SPECIALTY_FW, '') as 'Vendor Specialty',
COALESCE(T1.VENDOR_TYPE_FW, '') as 'Vendor Type',

CASE 
	WHEN T1.SUPSTATUS_FW = '0' THEN ''
	WHEN T1.SUPSTATUS_FW = '1' THEN 'YES'
	ELSE ''
END,

COALESCE(CONVERT(varchar(10), T2.START_DATE_FW, 101), '') as 'Start Date',
COALESCE(CONVERT(varchar(10), T2.END_DATE_FW, 101), '') as 'End Date',

SQL 2008 How to specify column name when using case statement

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.