Hi Dave and Mark,
Here's the code I came up with. It's not the prettiest code.
<!--Email Group Variables:-->
<gel:parameter default="TRG Resource Administrator" var="EMAILGROUP"/>
<core:set value="0" var="emailCount"/>
<!--Email Group Variables:-->
<!--e_group used to loop through group specified in EMAILGROUP and create email with all addresses-->
<sql:query var="e_group">
SELECT u.email_address
FROM CMN_CAPTIONS_NLS NLS,
cmn_sec_users u,
CMN_SEC_GROUPS G,
cmn_sec_user_groups UG,
CMN_LOOKUPS L,
srm_resources r
WHERE NLS.TABLE_NAME = 'CMN_SEC_GROUPS'
AND NLS.PK_ID = G.ID
AND NLS.LANGUAGE_CODE = 'en'
AND u.id = ug.user_id
AND
u.id = r.user_id
AND G.GROUP_TYPE_ID = L.ID
and g.id = ug.group_id
AND L.LOOKUP_TYPE = 'SEC_GROUP_TYPE'
AND
g.is_active = '1'
AND
r.is_active = '1'
AND NLS.name = '${EMAILGROUP}'
</sql:query>
<!--count_e_group used to count active members of group specified in EMAILGROUP and create email with all addresses-->
<sql:query var="count_e_group">
SELECT count(*) as num
FROM CMN_CAPTIONS_NLS NLS,
cmn_sec_users u,
CMN_SEC_GROUPS G,
cmn_sec_user_groups UG,
CMN_LOOKUPS L,
srm_resources r
WHERE NLS.TABLE_NAME = 'CMN_SEC_GROUPS'
AND NLS.PK_ID = G.ID
AND NLS.LANGUAGE_CODE = 'en'
AND u.id = ug.user_id
AND
u.id = r.user_id
AND G.GROUP_TYPE_ID = L.ID
and g.id = ug.group_id
AND L.LOOKUP_TYPE = 'SEC_GROUP_TYPE'
AND
g.is_active = '1'
AND
r.is_active = '1'
AND NLS.name = '${EMAILGROUP}'
</sql:query>
<!--Loop through e_group (note 3 tests: >0 >1 =0 -->
<core:if test="${count_e_group.rows[0].num == 1}">
<core:set value="${e_group.rows[0].email_address}" var="email_addr"/>
</core:if>
<core:if test="${count_e_group.rows[0].num > 1}">
<!--Write first record-->
<core:set value="${e_group.rows[0].email_address}" var="email_addr"/>
<!--Write each subsequent record with a semi colon-->
<core:forEach begin="1" items="${e_group.rows}" trim="true" var="email_row">
<core:set value="${email_addr};${email_row.email_address}" var="email_addr"/>
</core:forEach>
</core:if>
<core:if test="${count_e_group.rows[0].num == 0}">
<core:set value="Clarity@regence.com" var="email_addr"/>
</core:if>