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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center