> How is a single variable going to help? If you were to use some > variables based approach, you would need one variable for each row of > the resultset, not one variable for the whole resultset.
I see. I figured it would work the same as the middlename variable which has a middlename for each record. I was trying to initialize middlename instead of doing it with the AS statement later. > If you just want to make sure the middlename is not NULL you simply > need > to expand your CASE statement: > CASE > WHEN o.mname is not null THEN o.fname > WHEN a.a_mname is not null THEN a.a_mname > ELSE ' ' > END as middlename This works great. I did try expanding the case statement, but clearly not well. I'll be able to use this immediately in two other queries. I truly appreciate the assistance. Thank you. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
