Wednesday, 20 January 2021

Query: How can I combine several fields to one field

Select U_Na + CHAR(13) + CHAR(10) + U_Ad+ CHAR(13) + CHAR(10) + U_AN2+ CHAR(13) + CHAR(10) + U_AD3 + CHAR(13) + CHAR(10) + + U_SP + CHAR(13) + CHAR(10) + U_BL+ CHAR(13) + CHAR(10) + U_CT+ CHAR(13) + CHAR(10) + U_ZC+ CHAR(13) + CHAR(10) + U_CU+ CHAR(13) + CHAR(10) + U_CR+ CHAR(13) + CHAR(10) FROM [dbo].[@RM_BY_LC] Where U_Bu= $[@RM_LC.U_Con]

No comments :

Post a Comment