34,590
社区成员
发帖
与我相关
我的任务
分享
用CHARINDEX(' ',GID)<=0
charindex(' ',rtrim(ltrim(groupid)))>0
create table test(gid varchar(20))
insert into test
select '001G 0000059' union all
select '001G00000000'
go
SELECT * FROM test WHERE CHARINDEX(' ',gid )=0
gid
--------------------
001G00000000
(所影响的行数为 1 行)
SELECT * FROM TB WHERE CHARINDEX(' ',groupid )>0 --选择groupid含空白的记录
SELECT * FROM TB WHERE CHARINDEX(' ',groupid )>0
replace(groupid,' ','')