sql="select * from [User] where Username like ‘%Username%‘ or Xuehao like '%Xuehao%' or Department like '%Department%' Biyear like '%Biyear%'order by UserID desc "


好像不行咧,提示出错，请各位指点一下!谢谢!!!

可以具体写出来吗?
   谢谢!

sql="select * from [User] where Username like ‘%"&Username&"%‘ or Xuehao like '%"&Xuehao&"%' or Department like '%"&Department&"%' Biyear like '%"&Biyear&"%'order by UserID desc "



是这样子吗?
  哪位高手来指点小弟一下咯!谢谢!!!

我已经换成英文状态的啦!
还是不行!
 大哥,你就写出来给我看看啦!

怎么还是不行咧...

错误类型：
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'Username like '%%' or Xuehao like '%23%' or Department like '%%' Biyear like '%%'' 中。