Need a query help

Hi All

Is this possible to create one filed from multiple field ?

Like I need address of business partner on invoice from CRD1

but in crd 1 all address save in seprate fields .

i need those fields in one field on oinv

SELECT T0.[Address]+ T0.[Building]+ T0.[Block]+ T0.[StreetNo]+ T0.[Street]+T0.[City]+

T0.[ZipCode]+ T0.[State] as'Address' FROM CRD1 T0​