select * from tblTest where charindex(name ,'abcdefgh' )>0
select * from tb where charindex('abcdefgh',name)>0 select * from tb where patindex('%abcdefgh%',name)>0select * from tb where name like '%abcdefgh%'
狙击啊.. 人家说不能用charindex啊.
like 也不能用吗? 那 select * from tb where replace('abcdefgh',name,'')< 8
楼上说过用 select * from tb where replace('abcdefgh',name,'') < 8 但是'abcdefgh'其实是个变量,不一定是8位,可能很多,请帮忙继续想想
--这样? --> 测试数据: @os declare @os table (id int,name varchar(5)) insert into @os select 1,'abcde' union all select 2,'de' union all select 3,'cde' union all select 4,'abd' union all select 5,'bcde' union all select 6,'abe' union all select 6,'xyz'declare @name varchar(50) set @name='abcdefghij' select * from @os where len(replace(@name,name,''))<len(@name)
declare @str varchar(100) set @str='abcdefgh' select * from tblTest where @str like '%'+name+'%' --> or select * from tblTest where @str replace(@str,name,'')<>@str
declare @str varchar(100) set @str='abcdefgh' select * from tblTest where @str like '%'+name+'%' --> 笔误: select * from tblTest where replace(@str,name,'')<>@str
select * from tb where patindex('%abcdefgh%',name)>0select * from tb where name like '%abcdefgh%'
人家说不能用charindex啊.
like 也不能用吗?
那
select * from tb
where replace('abcdefgh',name,'')< 8
楼上说过用
select * from tb
where replace('abcdefgh',name,'') < 8 但是'abcdefgh'其实是个变量,不一定是8位,可能很多,请帮忙继续想想
--这样?
--> 测试数据: @os
declare @os table (id int,name varchar(5))
insert into @os
select 1,'abcde' union all
select 2,'de' union all
select 3,'cde' union all
select 4,'abd' union all
select 5,'bcde' union all
select 6,'abe' union all
select 6,'xyz'declare @name varchar(50)
set @name='abcdefghij'
select * from @os where len(replace(@name,name,''))<len(@name)
declare @str varchar(100)
set @str='abcdefgh'
select * from tblTest where @str like '%'+name+'%'
--> or
select * from tblTest where @str replace(@str,name,'')<>@str
set @str='abcdefgh'
select * from tblTest where @str like '%'+name+'%'
--> 笔误:
select * from tblTest where replace(@str,name,'')<>@str
好想法
select * from tblTest where 'abcdefgh' like '%'+name+'%'
应该是select * from tblTest where name like '%abcd%'吧
新手,不知道这是不是一样的
只有23楼的可以了。
不错,顶!
Select * from tblTest where name like '%abcdefgh%'
select * from tblTest where 'abcdefgh' like name ??????????
呵呵
select * from tblTest where 'abcdefgh' like '*'+name+'*'