rs1.Open "select * from db_mrp where rtrim(存货编码) ='" & RTrim(XL.Cells(i, 11)) & "'and rtrim(宽度)='" & RTrim(XL.Cells(i, 12)) & "'", cnn, adOpenKeyset, adLockOptimistic

如以上语句,改成以下语句,会出错.
rs1.Open "select * from db_mrp where trim(存货编码) ='" & Trim(XL.Cells(i, 11)) & "'and trim(宽度)='" & RTrim(XL.Cells(i, 12)) & "'", cnn, adOpenKeyset, adLockOptimistic

应该怎样改呢?

sql语法中没有直接去除两头空格的函数，但有ltrim()去除左空格rtrim()去除右空格。
合起来用就是sql的trim()函数，即select ltrim(rtrim(UsrName))