CFSelect Dropdownvalue Problem

[CoachPrincess]

When the following code is run, if there are any blanks in the fields, none of the values appear in the drop down box.

Code:
<cfquery>
SELECT Customer_Number, Hospital_System_Name, Hospital_Name, Address1, City, State,
Customer_Number+' '+Hospital_System_Name+' '+Hospital_Name+' '+Address1+' '+City+' '+State+'' as dropdownvalue
FROM Customer
WHERE Customer.Agency_Name = '#Agency_Name#'
</cfquery>

<cfoutput><cfselect>
</cfselect></cfoutput>

What is wrong with my code?

[cindy]

Are you sure the blanks aren't Nulls? NULL + anything else = NULL.

If you concatenate a NULL value with anything else, the result is NULL. This is an ANSI behavior. You have to use whatever function your DB has to replace NULLs with actual blank values.