Replace SQL SERVER between columns

Question

How to replace between columns in SQL SERVER. For example, given the table below:

COLUNA_A | COLUNA B | COLUNA_C
A          123        casa

I tried to run the query:

SELECT REPLACE(COLUNA_C, COLUNA_A, COLUNA_B ) FROM TABELA

To try to get the result:

COLUNA_A | COLUNA B | COLUNA_C
A          123        c123s123

But it didn’t work. How can I do this replace using column values?

If you do so:

SELECT REPLACE(COLUNA_C, 'a', COLUNA_B ) FROM TABELA

works normally. Even I tried to use a cast or Convert in COLUNA_A E COLUNA_B, inside replace, also unsuccessfully.

Answer 1

The construction with the REPLACE() function is correct. If it did not work, one hypothesis is that the columns are defined with grouping case sensitive. If that is the case, A is different from a.

To assess whether the reason is grouping case sensitive, try it:

-- código #1 v2
IF Object_ID('TABELA','U') is not null
  DROP TABLE dbo.TABELA;
go

CREATE TABLE dbo.TABELA (
     coluna_A varchar(20) collate Latin1_General_CS_AS, 
     coluna_B varchar(20) collate Latin1_General_CS_AS, 
     coluna_C varchar(20) collate Latin1_General_CS_AS
);

INSERT into dbo.TABELA (coluna_A, coluna_B, coluna_C) values
  ('A', '123', 'casa_X'),
  ('a', '123', 'casa_Y');

SELECT replace (coluna_C, coluna_A, coluna_B)
  from dbo.TABELA;

SELECT replace (coluna_C collate Latin1_General_CI_AS, coluna_A, coluna_B)
  from dbo.TABELA;

I did not test code #1 after modification. May contain error(s).