<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
帮忙写个select * from mydtata where (不麻烦的)
问题是这样的:
selet * from mydata where 年份= ''2005 '' ...
现在要求筛选出 "年份 "(字符串类型的) 是 2005 和 2006的项
__________________________________________________________________________
SQL Server :
select * from mydata where CHARINDEX(年份, ''2005 '') > 0 OR CHARINDEX(年份, ''2006 '') > 0
Oracle
select * from mydata where instr(年份, ''2005 '') > 0 OR instr(年份, ''2006 '') > 0
__________________________________________________________________________
不好意思,忘说了,我用VB 连接的是ACCESS数据库
这个答了,分就给你了
__________________________________________________________________________
selet * from mydata where 年份= ''2005 '' or 年份= ''2006 ''
__________________________________________________________________________
谢谢了
__________________________________________________________________________
Accsess:
select * from mydata where instr(年份, ''2005 '') > 0 OR instr(年份, ''2006 '') > 0
__________________________________________________________________________
帮忙写个select * from mydtata where (不麻烦的)
问题是这样的:
selet * from mydata where 年份= ''2005 '' ...
现在要求筛选出 "年份 "(字符串类型的) 是 2005 和 2006的项
__________________________________________________________________________
SQL Server :
select * from mydata where CHARINDEX(年份, ''2005 '') > 0 OR CHARINDEX(年份, ''2006 '') > 0
Oracle
select * from mydata where instr(年份, ''2005 '') > 0 OR instr(年份, ''2006 '') > 0
__________________________________________________________________________
不好意思,忘说了,我用VB 连接的是ACCESS数据库
这个答了,分就给你了
__________________________________________________________________________
selet * from mydata where 年份= ''2005 '' or 年份= ''2006 ''
__________________________________________________________________________
谢谢了
__________________________________________________________________________
Accsess:
select * from mydata where instr(年份, ''2005 '') > 0 OR instr(年份, ''2006 '') > 0
__________________________________________________________________________