一个有关字段内含有下划线查询的SQL语句问题

[Tranlynn]

SQL SERVER 2005数据表中有个字段带有下划线，如字段名称为：批文_省级、批文_部级，现在我需要对这两个字段进行模糊查询，请问SQL语句怎么写？

[哥眼神纯洁不]

where left(字段,charindex('_',字段)-1) like xxx --'-'左边的
and right(字段,len(字段)-charindex('_',字段)) like xxx --'-'右边的

[曲军昌]

create table #tb
(
    name varchar(50) not null,
)
go
insert into #tb(name) values('批文_省级'),('批文_部级')
select name from #tb where name like N'%省%'
name
--------------------------------------------------
批文_省级

(1 行受影响)

[zhuode_001]

服务器 (2013-01-25 9:12:56)
CREATE TABLE [Table3] (
	[test_id] [int] NOT NULL ,
	[批文_省级] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[批文_部级] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO


insert into Table3
select 1,'s2013001','b2013001'

insert into Table3
select 2,'s2013002','b2013002'

insert into Table3
select 3,'s2013003','b2013004'


select * from table3
where 批文_省级 like '_201300_'

[编程小白_大场]

select * from 表名 where 批文_省级 like '%_省级' or 批文_部级 like '%_部级'

[lizongbao201]

where charindex('_部级' ,批文)>0 union all where charindex('_省级' ,批文)>0

[szm341]

到底是字段名带下划线还是字段中的数据带有下划线啊。。。