Can't seem to concatenate code

1

SELECT
json_extract_path_text(olrph.RESPONSE, 'code') AS code,
json_extract_path_text(olrph.RESPONSE, 'data.code') AS datacode,
json_extract_path_text(olrph.RESPONSE, 'response.data.code') AS responsedatacode,
FROM
olrph;

I can't seem to get this to concatenate.

SELECT
json_extract_path_text(olrph.RESPONSE, 'code') AS code,
json_extract_path_text(olrph.RESPONSE, 'data.code') AS datacode,
json_extract_path_text(olrph.RESPONSE, 'response.data.code') AS responsedatacode,
CONCAT_WS('',json_extract_path_text(olrph.RESPONSE, 'code'), json_extract_path_text(olrph.RESPONSE, 'data.code'), json_extract_path_text(olrph.RESPONSE, 'response.data.code')) AS concatenated_strings
FROM
olrph;

I have tried various ways but the column appears as blank

2

Do you have a lot of NULL values? Try the ISNULL function to avoid this. Why do you use CONCAT_WS without a seperator? You can use CONCAT instead or am I missing something?

CONCAT_WS (Transact-SQL) - SQL Server | Microsoft Learn

CONCAT (Transact-SQL) - SQL Server | Microsoft Learn

CONCAT_WS('',ISNULL(json_extract_path_text(olrph.RESPONSE, 'code').''), ISNULL(json_extract_path_text(olrph.RESPONSE, 'data.code'),''), ISNULL(json_extract_path_text(olrph.RESPONSE, 'response.data.code').'')) AS concatenated_strings