SQL 中按单词排序

Question

例如，

我有单词“John Roshan”，我想按每个单词的第一个字母来排列此顺序，这意味着上述单词的输出应该是“Roshan John”。

我想用 SQL 来做，

请帮我解决这个问题。

提前致谢

Answer 1

declare @S varchar(50)
set @S = 'John Roshan 2000'

;with cte as
(
  select 
    1 as P1,
    charindex(' ', @S+' ', 1) as P2
  union all
  select
    C.P2+1,
    charindex(' ', @S+' ', C.P2+1) as P2
  from cte as C
  where charindex(' ', @S+' ', C.P2+1) > 0
)

select
(
  select substring(@S, P1, P2-P1)+' '
  from cte
  order by substring(@S, P1, P2-P1)
  for xml path(''), type
).value('.', 'varchar(50)')