I am doing a select statement in C code but I need to concatenate two fields from our informix database:
aa_rec.aa = $pcode and aa_rec.id = $nslc_buf.id
and ( aa_rec.end_date is null
or aa_rec.end_date >= today
or aa_rec.end_date = 0);
I need line1 and line2 from aa_rec to be combined into $email_id
I don't do C code much anymore, so any help you can give to help me remember the syntax would be great!