sql="select * from [User] where Username like '%"&Username&"%' or Xuehao like '%"&Xuehao&"%' or Department like '%"&Department&"%' or Biyear like '%"&Biyear&"%'order by UserID desc "
Biyear前面少了一个"or"

[[it] 本帖最后由 madpbpl 于 2008-7-28 10:28 编辑 [/it]]