InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:49:20 GMT20http://www.sqlservercentral.com/Forums/Topic927067-338-1.aspxEverything is doing what it should. I end up with a 2 column HTML table using the following code, but I'd like to set the background color, [b]conditionally[/b], and at the [b]cell level[/b].[code="sql"]SET @tableHTML = N'Your data ........................email.' + N'<b>Property: </b>' + @prop + N'<b>Submitted: </b>' + @insert_dt + N'<b>Submit Type: </b>' + @zsubtype + N'<table border="1 "cellpadding="10">' + N'<tr><th align="center">Month</th><th align="center">Issue</th></tr>' + CAST ( ( SELECT td = ph.occ_month, ' ', -- xml col separator td = COALESCE(ds.descr,'--') FROM #phold ph LEFT OUTER JOIN datasub_CHK ds ON ph.months_out = ds.val1-1 FOR XML PATH('tr'), TYPE ) AS NVARCHAR(MAX) ) + N'</table>'[/code]I'm trying to get "<td bgcolor="red">" into the @tableHTML statement ONLY WHEN the second column of the SQL statement is a certain value (<> "--")Has anyone done this? I can't screw with the SQL portion of the code without fouling the whole show.Thank you!Mon, 24 May 2010 14:20:26 GMTGreg J