SQL Server doesn't have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this.

<pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName
FROM YourTable</pre>

I wrapped the MiddleName column within a CASE statement so that if it's NULL it leaves the middle name out. If you want the blank field if the MiddleName is NULL then you'll want something like this.

<pre>SELECT FirstName + ', ' + ISNULL(MiddleName) + ', ' + LastName
FROM YourTable</pre>

Tiny modification use an As to give column name-

<pre>SELECT (FirstName + ', ' + ISNULL(MiddleName) + ', ' + LastName) as FullName
FROM YourTable</pre>

SQL Server doesn't have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this. <pre><pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName FROM YourTable</pre></pre> I wrapped the MiddleName column within a CASE statement so that if it's NULL it leaves the middle name out. If you want the blank field if the MiddleName is NULL then you'll want something like this. <pre><pre>SELECT FirstName + ', ' + ISNULL(MiddleName) + ', ' + LastName FROM YourTable</pre></pre> Tiny modification use an As to give column name- <pre><pre>SELECT (FirstName + ', ' + ISNULL(MiddleName) + ', ' + LastName) as FullName FROM YourTable</pre></pre>