Post reply

How to split single name with space in sql

  • 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:58 am

    #4018925

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

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

  • April 20, 2022 at 12:20 pm

    #4019231

    Ty so much, It worked!!!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply