To simplify, I have 2 tables joined on ID. The second table has several columns containing different type of comment. and can have several rows joined to the first table
What I need is if any of the comment fields have a value (Len(comment1)>0 or Len(comment2) >0 ) I return a flag of 1 in the dataset.
What I'm finding is that I get a row for each in the joined comment table, I just want a flag indicating that any row in the joined table has a comment in any field.