Tag: string-concatenation

How can I use IF and CONCAT within SELECT

I have this Adjacency List Model table Table: Output: So I have the following query that duplicates a Site 1 e.g. and its children. In this case, the children are Paper with parent_id = 2 and ms1 with parent_id = 3 Output: As you can see Site 1 and its children got duplicated with a new unique id. However for

How to limit STUFF function within CTE for removing character before recurring word

sql sql-server string-concatenation tsql

A follow up question for Replace a recurring word and the character before it Credit to @Larnu for the following code, how would this code be modified to not produce a null value if there is no longer a character before a recurring word, “[BACKSPACE]”. I believe the null value is occurring because…

Replace a recurring word and the character before it

sql sql-server string-concatenation tsql

I am using SQL Server trying to replace each recurring “[BACKSPACE]” in a string and the character that came before the word [BACKSPACE] to mimic what a backspace would do. Here is my current string: “This is a string that I would like to d[BACKSPACE]correct and see if I could make it %[BACK…

Presto equivalent of CONCAT_WS

presto sql string-concatenation

I’m looking for a function in Presto to concat two columns with a separator like underline. Answer Your are looking here for the array_join function, see docs. array_join(x, delimiter, null_replacement) → varchar Concatenates the elements of the given array using the delimiter and an optional string to …

oracle SQL Concatenate 2 columns based on condition

oracle sql string-concatenation

let’s say i have a table : +—-+————+————+ | ID | NAME1 | NAME2 | +—-+————+————+ | A1 | DAVE | DAN | | A1 | DOR | MON | | A2 | …

Column Concatenation in Oracle [closed]

oracle sql string-concatenation

I’m trying to Concatenate these three columns into one but having the error, any help? WITH ABC AS (select tsk.task_number || ‘ / ‘|| tsk.task_status|| ‘ / ‘|| tsk.summary, CSI….