To remove spaces between columns in the results of a SQL query, you can use the CONCAT function to concatenate the values of each column together into a single string. Here is an example of how you can use the CONCAT function to remove spaces between columns in the results of a SELECT statement:

SELECT CONCAT(column1, column2, column3) FROM table;

Alternatively, you can also use the CONCAT_WS function which is used for concatenating the values of each column together into a single string and it also allows you to specify a separator. Here is an example of how you can use the CONCAT_WS function to remove spaces between columns in the results of a SELECT statement:

SELECT CONCAT_WS('', column1, column2, column3) FROM table;

You can also use the TRIM function to remove spaces at the beginning and end of each column value. Here is an example of how you can use the TRIM function to remove spaces between columns in the results of a SELECT statement:

SELECT TRIM(column1) || TRIM(column2) || TRIM(column3) FROM table;

Please keep in mind that the specific function and syntax used to remove spaces between columns in the results of a SQL query may vary depending on the specific SQL database you are using.