谁会想到（Image类型）的这个问题？

[xboypunk2004]

某表A有一Image类型列ima,现已知该列中包含数据 0XBBBFBFBF........
有什么办法可以查出该列包含 %BBBFB%
就像select * from A where ima like %BBBFB%
当然我这个办法是不行的。所以求助大师门。

[oooooo126]

select * from 表 where convert(varchar(max),image字段) like '%BBBFB%'

[oooooo126]

错了，顶

[gc_ding]

select * from A where cast(ima as varbinary) like '%BBBFB%'

[xboypunk2004]

不对啊。查不出来。。。我的是SQLSERVER2005

[Tigersong]

select * from A where PATINDEX('%BBBFB%',ima)>0

[Tigersong]

select * from A where SUBSTRING(ima,1,8000) like '%BBBFB%'

[xboypunk2004]

不行啊

[study_boy]

如果你语句没错的话，试试这样写，我前天也遇到过和你相似的情况

'select * from (select top '+ Cast(@num1 as nvarchar(100)) + ' percent * from test where testCourse=''ccjxtjc'' order by newid())a union all
select * from (select top '+ Cast(@num2 as nvarchar(100)) + ' percent * from test where testCourse=''dyjxl'' order by newid())b union all
select * from (select top '+ Cast(@num3 as nvarchar(100)) + ' percent * from test where testCourse=''qtks'' order by newid())c union all
select * from (select top '+ Cast(@num4 as nvarchar(100)) + ' percent * from test where testCourse=''rjbf'' order by newid())d union all
select * from (select top '+ Cast(@num5 as nvarchar(100)) + ' percent * from test where testCourse=''smyxl'' order by newid())e union all
select * from (select top '+ Cast(@num6 as nvarchar(100)) + ' percent * from test where testCourse=''yjwxjs'' order by newid())f)h'

[study_boy]

发错地方了，不好意思^^！！！