Problem with sql column formula -- null / concat
I've got the folowing formula for a computed column (LeadFullName) in the database design portion of vs2003.
([LeadFirstName] + ' ' + [LeadMidInitial] + ' ' + [LeadLastName])
Unfortuantely, Lead middle initial was added as a new column, so is null for all existing records. So all the existing records with null middle names show LeadFullName as null. I understand there are various ways to fix this, but I'm not sure how to implement in a formula.
Any help would be appreciated
([LeadFirstName] + ' ' + COALESCE([LeadMidInitial], '') + ' ' + [LeadLastName])
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
Success - Problem with sql column formula -- null / concat
It worked perfectly! I had searched all over the internet, and only come up with ws_concat (which I couldn't get to work) and ifnull logic (that seemed pretty complex.
Thanks for the quick, Sunday reply!
By Guillermo Hidalgo in forum XML
Last Post: 05-22-2002, 04:49 AM
By Randy Williams in forum XML
Last Post: 05-25-2001, 08:03 AM
By Becky in forum Database
Last Post: 07-11-2000, 04:27 PM
By Devaraj in forum Enterprise
Last Post: 05-11-2000, 01:48 PM
By Bob Hines in forum Database
Last Post: 04-27-2000, 12:14 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL