How to split single name with space in sql

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  April 20, 2022 at 12:03 am

  #4018876

  I have  table data with stores like

  select Name from tblstudent

  Result will be Southeri,Brettuen

  I need space after comma  (Result should be like Southeri, Brettuen)

   

  How can we achieve this?

   

• April 20, 2022 at 2:55 am

  This was removed by the editor as SPAM

• jmetape

  Right there with Babe

  Points: 731

  More actions

  April 20, 2022 at 2:58 am

  #4018925

  declare @text varchar(100) = 'Southeri,Brettuen'

  select @text, Replace(@text, ',' ,', ')

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  April 20, 2022 at 12:20 pm

  #4019231

  Ty so much, It worked!!!