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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem - thank you. Cheers, Paul
ASKER