<div>
THANK YOU - &nbsp;that was the trick!
</div>


<div>
<div class="content wysiwyg-content">
I want to accomplish the equivalent of:<br />

<div class="indent">
<i>if both first and last names are NULL, &nbsp;then substitute &quot;Customer&quot; &nbsp;for the first name<br />
otherwise pass-thru &nbsp;Fname and Lname.</i>
</div>
<br />
I don't think nested &nbsp; &nbsp;IFNULL &nbsp;will do it because two fields are being tested but only one returned.<br />
<br />
I need in the end to yield two separate fields returned &nbsp;(First, Last) -- for a salutation (Dear Customer)<br />
<br />
something like... &nbsp;<i> but i can't get the NULL parts right.</i><br />

<pre><code id="code-10-28030376-1">SELECT    IF( CONCAT(Fname,Lname) ISNULL ,  &quot;Customer&quot;,  Fname) AS FirstName, Lname AS LastName</code></pre>
</div>
</div>


I want to accomplish the equivalent of:
if both first and last names are NULL,  then substitute "Customer"  for the first name
otherwise pass-thru  Fname and Lname.

I don't think nested    IFNULL  will do it because two fields are being tested but only one returned.

I need in the end to yield two separate fields returned  (First, Last) -- for a salutation (Dear Customer)

something like...   but i can't get the NULL parts right.
(CODE)

mySQL IF stmt within SELECT list

I want to accomplish the equivalent of:
if both first and last names are NULL,  then substitute &quot;Customer&quot;  for the first name
otherwise pass-thru  Fname and Lname.

I don&#39;t think nested    IFNULL  will do it because two fields are being tested but only one returned.

I need in the end to yield two separate fields returned  (First, Last) -- for a salutation (Dear Customer)

something like...   but i can&#39;t get the NULL parts right.
(CODE)

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.