Hey everyone. Like a lot of others here, I am excellent at excel but new to coding so any help would truly be appreciated. I have a membership database within our site that every so often has to be exported and sent elsewhere for records purposes. Because of this, instead of using code on the front end on specific pages to show a combined name, I created a column within the database where an afterQuery code is used to combine the members complete name (prefix, first, middle, last, and suffix).
This has worked as expected however now I am running into the issue where "null" is also being added into the name for the fields of data where a person may not have a prefix, middle name, or suffix. Is there additional code that I could add to help keep the "null" out of the name? From what I searched in the forums, a few answers were only related to when the name was combined and displayed on a page. Unfortunately, I need to figure it out for the database end. Thank you for any help you can provide. Below is a snap shot of the code and the results to give you an idea where I am at.