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