SQL Replace comma in results without replacement

Question

It seems to me that this should be quite simple, but they did not find solutions that have not yet used a replacement. I have the following select statement that I run, and for some columns there are commas separating the values. I would like to replace these commas with a semicolon, however I only want to do this in the select statement. I do not want him to change the values ​​in the tables at all. This is also not a single expression, or I would just replace all the commas with a semicolon, and then go back.

SELECT a.Category_Id, a.Category_Name, ISNULL(b.Category_Alias, '') as Category_Alias, ISNULL(b.SUPPORT_NAMES, '') as SUPPORT_NAMES FROM Categories a INNER JOIN CategoryInfo b on b.Category_Id=a.Category_Id 

For the Category_Alias ​​column, the entries are actually stored as CS, Customer Support , and I want this to display as CS; Customer Support CS; Customer Support for the select statement only.

Answer 1

I believe that you may be confused by what the REPLACE function does. You can use REPLACE in a SELECT statement without changing the data in the database:

 SELECT REPLACE(MyField, ',', ';') AS NewFieldName FROM MyTable 

Answer 2

I believe that you do not want to physically replace the value in the table, but ok replace when you select

So you can

 Select REPLACE(ColumnName,',',';') From TableName 

Answer 3

Most SQL servers implement a built-in replacement function. Most of them are called replace (), and can also be used in a select statement. An example from MySQL:

 SELECT field, REPLACE(field,',',';') FROM my_table;