<div>
cant you just do<br />
<br />
select lastName &amp;&nbsp;coalesce(firstName &amp;&nbsp;&quot;,&quot;, &quot;&quot;) from tableName
</div>


cant you just do

select lastName & coalesce(firstName & ",", "") from tableName

<div>
or this may work<br />
select lastName + coalesce(firstName &amp;&nbsp;', ', '') as pName from tableName
</div>


or this may work
select lastName + coalesce(firstName & ', ', '') as pName from tableName

<div>
This is a duplicate question that exceeds the maximum 500 allowed. &nbsp; Please post a message in Community Support to have the points reducd in both threads as you have valid comments in both. &nbsp;See here:<br />
<a href="https://www.experts-exchange.com/questions/22035147/Simple-SQL-question-URGENT.html" rel="ugc">https://www.experts-exchange.com/questions/22035147/Simple-SQL-question-URGENT.html</a><br />

</div>


This is a duplicate question that exceeds the maximum 500 allowed.   Please post a message in Community Support to have the points reducd in both threads as you have valid comments in both.  See here:
https://www.experts-exchange.com/questions/22035147/Simple-SQL-question-URGENT.html [https://www.experts-exchange.com/questions/22035147/Simple-SQL-question-URGENT.html]


<div>
@meixell, please ask for a refund from CS of your points as this has already been answered in your other link.
</div>


@meixell, please ask for a refund from CS of your points as this has already been answered in your other link.

<div>
Yea.. Sorry about the dual post. I didn't think my submission went through the first time.<br />
<br />
<br />

</div>


Yea.. Sorry about the dual post. I didn't think my submission went through the first time.




<div>
<div class="content wysiwyg-content">
 <br />
I have a table with a first name and a last name column. What I want is to return only the last name if the first name is null, but (last name + &quot;, &quot;&nbsp;+ first name) otherwise. <br />
<br />
Any suggestions on how to do this without having to muck with a procedure? MySQL has a CONCAT_WS() (ws = with separator) function that does what I want, but I haven't been able to find any simple equivalent from Microsoft. <br />
&nbsp;<br />

</div>
</div>


 
I have a table with a first name and a last name column. What I want is to return only the last name if the first name is null, but (last name + ", " + first name) otherwise. 

Any suggestions on how to do this without having to muck with a procedure? MySQL has a CONCAT_WS() (ws = with separator) function that does what I want, but I haven't been able to find any simple equivalent from Microsoft. 
 


simple Microsoft SQL question..   URGENT

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.