I've built a database table with standard FirstName & LastName columns. I'm calling it into a dynamic page using SELECT [FirstName] + " " + [LastName] AS Name ORDER BY LastName. Everything working fine, until my client needs to insert a company name instead of an persons name. Since the results are ordered by LastName, the best sorting scheme is to list the company name as the last name. But then when it's displayed to the page FirstName = NULL, and the result of concatenating that is also NULL.

How can I deal with companies so that they are easy to insert, orders alphabetically with people's last names, and displays on the page?

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

Do something like this:

SELECT
  ISNULL(FirstName, '') + " " + ISNULL(LastName, '') as Name
FROM
  [Table]

This will prevent the NULL value from being returned.
hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Thanks!

It helped a lot more once I realized it was comma empty string not comma double quote. ;)

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.