如表t1,字段A1(字符型);表t2,字段A2(字符型)。A1=‘020 ’(后面可能多个空格),A2=‘020’(没空格)语句:select * from t1 inner join t2 on A1=A2结果就是得不到。请教了。length(trim(A1)) 竟然是5? 真的是换行啊,那怎样消除掉啊? 答案:replace(A1,chr(10), '') = A2