7,763
社区成员
发帖
与我相关
我的任务
分享求SQL语句，或者能够解决的方法？？？给五十分！
表中有一字段，其中数据有“*”和数字的任意组合，也有全为数字的，在这两种数据中，怎么样把凡是有“*”的都筛掉？？？急人
...全文
请发表友善的回复…
发表回复
SFMN 2003-12-19
- 打赏
- 举报
谢谢各位兄弟，我试试先
Reker熊 2003-12-19
- 打赏
- 举报
SQL Server:
Select * from Tablename Where CharIndex('*',fieldName)=0
Select * from Tablename Where CharIndex('*',fieldName)=0
海牛 2003-12-19
- 打赏
- 举报
如果是Access数据库：
Select * From Table Where Instr(1,字段名称,'*')=0
Select * From Table Where Instr(1,字段名称,'*')=0
jhzhou882 2003-12-19
- 打赏
- 举报
USE pubs
GO
SELECT * FROM titles
WHERE PATINDEX('%*%', notes)<>0
GO
NOTES是列名
GO
SELECT * FROM titles
WHERE PATINDEX('%*%', notes)<>0
GO
NOTES是列名
jhzhou882 2003-12-19
- 打赏
- 举报
USE pubs
GO
SELECT * FROM titles
WHERE PATINDEX('%*%', notes)=0
GO
NOTES是列名
GO
SELECT * FROM titles
WHERE PATINDEX('%*%', notes)=0
GO
NOTES是列名
huayuxing 2003-12-19
- 打赏
- 举报
select * from people
where name not in (select name from people where name like '%*%')
where name not in (select name from people where name like '%*%')
rexyudl 2003-12-19
- 打赏
- 举报
slect * from biao where not in(select * from biao where col like ' % * % ')
SoHo_Andy 2003-12-19
- 打赏
- 举报
搞定了，试试
select * from people
where name not in (select name from people where name like '%*%')
select * from people
where name not in (select name from people where name like '%*%')
netcrawller 2003-12-19
- 打赏
- 举报
While Not rs.EOF
If InStr(1, rs(0), "*", vbTextCompare) <= 0 Then
'Do sth.
End If
rs.MoveNext
Wend
rs.Close
Set rs = Nothing
'未测试,就这个思想
If InStr(1, rs(0), "*", vbTextCompare) <= 0 Then
'Do sth.
End If
rs.MoveNext
Wend
rs.Close
Set rs = Nothing
'未测试,就这个思想
