Tested that out last night, it worked great! But another question, how do I place the Case Statements together? I tried this last night and it didn't work out.

CASE

CASE WHEN fmwa.GroupNbr<>'' THEN 'NO'

WHEN dind.DefaultIndicator='Y' THEN 'YES'

ELSE 'NO'

END AS Default_ID,

CASE WHEN tagagt.AgencyName=''

THEN RTrim(LTrim(tagagt.LastName)) + N', ' + RTrim(LTrim(tagagt.FirstName))

ELSE RTrim(LTrim(tagagt.AgencyName))

END AS WA_Name