急！！！

[继续泛泛]

select * from BaseArchives where jzdw in ('2,10,9,11')

[guguda2008]

select * from BaseArchives where jzdw in ('2','10','9',11')

[继续泛泛]

去掉引号

[csuxp2008]

没头没尾的...急个啥子哦

[Andy__Huang]

什么问题？没说清楚呢

[csuxp2008]

jzdw 若是数字类型，去掉两边的引号
若是字符类型，将每个数字加上单引号

[Andy__Huang]

select * from BaseArchives where charindex(','+cast(jzdw as varchar)+',' ',2,10,9,11,')>0

[继续泛泛]

不好意思，就是在程序中传过来了一个参数，是一个字符串，这样的
select * from BaseArchives where jzdw in (@a)怎么把@a单引号去掉

[王向飞]

declare @t nvarchar(200)
set @t = '''2'',''10'',''9'',''11'

declare @sql nvarchar(2000)
set @sql='select * from BaseArchives where jzdw in ('+replace (@t,'''','')+' )'
 print @sql 
exec @sql 

[small_tree]

楼主传入的@需要处理一下，就是把用分隔符把每个字段分开，可以用以下代码

DECLARE @str VARCHAR(max)
		,@seperator VARCHAR(max)
SELECT @str = '1,2,3,4,15,6,237'
	  ,@seperator = ','


DECLARE @tbl_split TABLE ( 
	 str_id	varchar(max) NOT NULL
	,string	varchar(max) NOT NULL
)


DECLARE @strlen INT
		--,@start INT
		,@position INT
		,@start INT
		,@sublen INT
		,@tempstr VARCHAR(max)
		,@tempid INT

SELECT  @strlen = LEN(@str)
	   ,@start = 1 
	   ,@sublen = 0
	   ,@position = 1 
	   ,@tempstr = ''
	   ,@tempid = 0
	   

IF RIGHT(@str,1)<>@seperator	 
BEGIN
	SELECT @str = @str+@seperator	
END  

WHILE (@position<=@strlen AND @position!=0 )
BEGIN
	IF(CHARINDEX(@seperator,@str,@position)!=0)
		SELECT @sublen=CHARINDEX(@seperator,@str,@position)-@position
	ELSE	
		SELECT @sublen  =@strlen-@position+1;

	IF @position<=@strlen
	BEGIN
		SELECT @tempid= @tempid +1
			   ,@tempstr =SUBSTRING(@str,@position,@sublen)
		
		INSERT INTO @tbl_split(str_id,string)
		VALUES(@tempid,@tempstr)
	
		IF(CHARINDEX(@seperator,@str,@position)!=0)		
			SELECT @position=CHARINDEX(@seperator,@str,@position)+1						
	END ELSE
		SELECT @position=@position+1
	
END
	   
	   
SELECT * FROM @tbl_split

[skypaul888]

程序去除引号后，再传过来啊