Hi, just wanted to some help in regards to removing spaces from my username column. I have used the following code to remove the double space to a single space.
regexp_replace(table_a.username, ' {2,}', ' ')
but when looking through my answers I have noticed that there is an extra in some names at the end of the field as well. The initial double space was between first name and last name but now I have to replace the end space completely, but not sure how.
If somebody could please advise.
Thanks in advance.