Do you mean like this:

SELECT

s_element.sendeplatz,

RTRIM (ISNULL(jingle.SzTitle, '')) + ' ' +

ISNULL (auths.szname, '') + ' ' +

ISNULL (comps.szname, '') + ' ' +

ISNULL (performs.szname, '') + ' ' +

ISNULL (arrangs.szname, '') + ' ' +

ISNULL (publisher.szname, '') + ' ' +

RTRIM (ISNULL(jingle.lid, '')) + ' ' +

RTRIM (ISNULL(jingle.szshortinfo, '')) AS CatColumn