Set LoadQx = Conn.Execute("SELECT userlist.UserID,userlist.Qxh,userlist.Qx,userperm.Bh,userperm.MC " & _
"From userperm,userlist Where userlist.UserID='" & UserID & "' And substring(userlist.qxh,3,4)=userperm.BH ")
substring(userlist.qxh,3,4)只需要从第3个字符开始,后不限长度,要如何操作.
"From userperm,userlist Where userlist.UserID='" & UserID & "' And substring(userlist.qxh,3,4)=userperm.BH ")
substring(userlist.qxh,3,4)只需要从第3个字符开始,后不限长度,要如何操作.
substring(userlist.qxh,3,len(userlist.qxh)-3)