sql 截图字符串问题

Question

SQL字段数据：与宝宝的关系：[爸爸]收件人：[张三]地址：[北京市大兴区黄村镇第七中学]
需要结果
与宝宝的关系      收件人      地址    
爸爸              张三     北京市大兴区黄村镇第七中学如何使用截图字符串 或者函数 来显示上面这个结果？

Answer 1

declare @s varchar(max)
set @s='与宝宝的关系：[爸爸]收件人：[张三]地址：[北京市大兴区黄村镇第七中学]'select 
  replace(replace(substring(@s,charindex('系',@s)+2,charindex('收',@s)-charindex('系',@s)-2),'[',''),']','') as 与宝宝的关系,
  replace(replace(substring(@s,charindex('人',@s)+2,charindex('地',@s)-charindex('人',@s)-2),'[',''),']','') as 收件人,
  replace(replace(substring(@s,charindex('址',@s)+2,len(@s)-charindex('人',@s)-2),'[',''),']','') as 地址
  
  /*与宝宝的关系                                                                                                                                                                                                                                                           收件人                                                                                                                                                                                                                                                              地址
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
爸爸                                                                                                                                                                                                                                                               张三                                                                                                                                                                                                                                                               北京市大兴区黄村镇第七中学             (1 行受影响)
*/