谁知道怎样在SQL中判断输入的字符串是否包含字符,号,没有则返回0,有多少个,号,就返回多少个~~
如:如果输入的是'sdfdsfd',则返回0
如果输入的是'sdfdsfd,',则返回1
如果输入的是'sdfdsfd,dsgdg,',则返回2,等等
如:如果输入的是'sdfdsfd',则返回0
如果输入的是'sdfdsfd,',则返回1
如果输入的是'sdfdsfd,dsgdg,',则返回2,等等
set @s ='sdfdsfd,dsgdg,'
select len(@s) -len (replace(@s,',',''))-----------
2(所影响的行数为 1 行)
SET @S = 'sdfdsfd'
SELECT LEN(@S) - LEN(REPLACE(@S, ',', ''))
SET @S = 'sdfdsfd,'
SELECT LEN(@S) - LEN(REPLACE(@S, ',', ''))
SET @S = 'sdfdsfd,dsgdg,'
SELECT LEN(@S) - LEN(REPLACE(@S, ',', ''))
set @s ='sdfdsfd,dsgdg,'
select len(@s) -len (replace(@s,',',''))-----------
2(所影响的行数为 1 行)
set @a='sdfdsfd,dsgdg,'
if charindex(',',@a) >0
select len(@a)-len(replace(@a,',',''))
else
print '0'
set @s ='gsdgatwerthdf,fgdfg,,'
select len(@s) -len (replace(@s,',',''))