I have an issue where I’m trying to retrieve the latest Date created row out of a ConCat column. But getting an error that it’s an invalid name. So I’m guessing you can’t do it this way?

I want to append data to a field in Issues.Comments from table Comments_Upload but I need to append the comments from c.Comments to any existing value in Issues.Comments and not just overwrite it. My code does not work when there is no existing value in i.Comments. How do I just update i.Comments with c.Comments if there is no existing value in i.Comments?

I’m using a TVF to return a list of recordID’s based on the deparment code of the primary project manager. The department code can include alpha and numeric characters so it’s defined as a varchar.