有关SQL语句请位大虾救助.....

[zhlym]

SQL="select * from sell where officename='"&trim(request.cookies("Myoffice"))&"' and instr(indate,'"&Keyword&"')) order by autoid desc "

以上语句,在ACCESS数据库里,可以输入关健词"2003-9"或"2003"这样查记录,提取数据库indate字段记录与2003-9或2003相同的记录读出来,其中indate为时间字段,请问在SQL里如何写一句跟这功能完全一样的语句,一定要功能一样,请各位指点.

[Primer2002cn]

SQL="select * from sell where year(indate)=2003 or month(indate)=9
order by autoid desc "

[zhlym]

老大,我的是查询语句,而且2003和9是不能分开的,要跟我用在ACCESS的语句功能一样才行,有办法吗?

[zhlym]

老大,我的是查询语句,而且2003和9是不能分开的,要跟我用在ACCESS的语句功能一样才行,有办法吗?

[zhlym]

请各位大虾不要看漏眼了,帮帮小弟

[liuzxit]

try...
SQL="select * from sell where officename='"&trim(request.cookies("Myoffice"))&"' and CHARINDEX(indate,'"&Keyword&"')) order by autoid desc "

[zhlym]

这句刚刚试过,行不通

[LONGFOR]

select * from sell where officename='"&trim(request.cookies("Myoffice"))&"'
convert(char(10),indate,120) like '"&keyword&"%'
是不是你想要的?

[zhlym]

select * from sell where officename='"&trim(request.cookies("Myoffice"))&"'
and convert(char(10),indate,120) like '"&keyword&"%'
这句是没问题可运行,但如查关健词2003-9这样却查不到？达不到我的要求，还有办法吗？

[LONGFOR]

select * from sell where officename='"&trim(request.cookies("Myoffice"))&"' and
convert(char(10),indate,120) like '"&keyword&"%' order by autoid desc

上面的括錯了,這個!!!!

[zhlym]

关注,两天的问题还是没解决,高手关注

[zhlym]

对面的高手看过来看过来,这里的问题好精彩,都两天了没解决