SQL Server - How to remover white spaces from a column

Hi Experts,
I have a column in my table where the last name and first name are separated by a comma,
e.g. Smith,  Joseph
The problem is that there are two spaces after the comma. I would like to have only one space following the comma. How can I achieve that? Thanks for your help.
romsomAsked:
Who is Participating?
 
PortletPaulConnect With a Mentor Commented:
REPLACE ( string_expression , string_pattern , string_replacement )

e.g.

replace(  full_name,   ',  '   ,   ', '  ) -- spread out to make it easier to read here

replace comma & two spaces with comma & one space
0
 
romsomAuthor Commented:
It worked, thank you very much!
0
 
PortletPaulCommented:
No problem - thank you. Cheers, Paul
0
All Courses

From novice to tech pro — start learning today.