用sqlserver将表中某一个字段按空格截取答:with [user](userid,name,age,medal) as ( select 100001, '张三', 20, '万元户 实名认证 宠物达人'union all select 100002, '李四', 30, '实名认证'),t as (select userid,cast(null as varchar(100)) medal,medal s from [user]union all select userid,cast(case when charindex('...