Replace a string in sql server

Question

I have the below text to replace in sql server. Is there any query to do so? The text is found in a column of a table.

Text before replace:

[demo].[demo_df__table_list__enum_table]

I want to replace the text and result should appear like this:

[[demo]].[demo_df__table_list__enum_table]]]

Where do you want to replace? an procedure? Try to be more clear — fnightangel
– fnightangel, Commented May 6, 2014 at 12:32
the value is stored in a variable and that variable should be replaced — Axs
– Axs, Commented May 6, 2014 at 12:33
[demo].[demo_df__table_list__enum_table] is stored in a variable. the query should check the format and replace the same — Axs
– Axs, Commented May 6, 2014 at 12:35

vhadalgi · Accepted Answer · 2014-05-06 12:40:27Z

4

try this !

declare @a as varchar(100)
set @a ='[demo].[demo_df__table_list__enum_table]'
select QUOTENAME(@a)

`see it live`

edited May 6, 2014 at 12:40

answered May 6, 2014 at 12:34

vhadalgi

7,2376 gold badges44 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Perrenoud · Accepted Answer · 2014-05-06 12:41:33Z

2

Yes, you can replace text in a column, for a row, like this:

UPDATE tbl
SET fld = REPLACE(fld,
    '[demo].[demo_df__table_list__enum_table]',
    '[[demo]].[demo_df__table_list__enum_table]]]')
WHERE [some condition here]

UPDATE: I see that you can use QUOTENAME as shown below, that's a good approach, but it still does you no good without the UPDATE statement. So the query would be:

UPDATE tbl
SET fld = REPLACE(fld, fld, QUOTENAME(fld))
WHERE [some condition here]

edited May 6, 2014 at 12:41

answered May 6, 2014 at 12:30

Mike Perrenoud

68.1k32 gold badges167 silver badges238 bronze badges

1 Comment

Mike Perrenoud Over a year ago

@user3425160, well now that the OP has updated their question I now know what text they are trying to replace with what. But the OP needs to leverage the REPLACE command to update a field in a table with new text. I'm not sure how it doesn't answer the question.

Farrukh shahzad · Accepted Answer · 2015-03-19 11:21:31Z

0

Replace is a function which takes three parametere: i;e Replace(Column Name,string literal to be replaced in Column,string literal to placed.) For examples G_DATE is Column 2015-03-09 2015-03-09 2015-03-09 2015-03-10 2015-03-10 2015-03-10 2015-03-12 2015-03-12 2015-03-12

UPDATE table SET G_DATE = REPLACE(G_DATE,'15','16') will give us

2016-03-09 2016-03-09 2016-03-09 2016-03-10 2016-03-10 2016-03-10 2016-03-12 2016-03-12 2016-03-12

answered Mar 19, 2015 at 11:21

Farrukh shahzad

152 bronze badges

Collectives™ on Stack Overflow

Replace a string in sql server

3 Answers 3

`see it live`

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related