First, Let’s have the table and its records:
Tag: duplicate
Replace duplicate spaces with a single space in SQL
SELECT REPLACE(REPLACE(REPLACE(‘ With this query you select single spaces’,’ ‘,'<>’),’><‘,”),'<>’,’ ‘) OUTPUT: With this query you select single spaces