按照你说的，CPGG应该是字符串，所以你最好把A.CPCDA.CPKD改成字符串，改成：CPGG=(CAST(A.CPCD AS varchar)+'*'+CAST(A.CPKD AS varchar))
