Similar Representation

[soha1902]

Hi All,

In my database from where I am fetching Names. Names are coming in different format for some names after first name space is available for some names its not availabe. So what I want to achieve if space is not present after comma(,) then it will add automatically during load. Please see below image:

[mdmukramali · Accepted solution]

!Dear ,

Use the replace function

Replace(Replace(A,', ',','),',',', ') as A,

kindly find the attached file.

Thanks,

Mukram

[soha1902]

Thanks a lot....