How to replace a string in a SQL Server Table Column with the same size of text

Question

I have a table (SQL Sever) with some values in it (Column name path), but now I want to update each row with a specific letter say x.

In the path column, I have many records and I need to change whatever the value in the path column with x, if a row is of 5 then the column will be replaced by xxxxx, if column is of length 9 then xxxxxxxxx to get in that place. And I need to change in every record.

How can I do this simply?

Yogesh Sharma · Accepted Answer · 2018-04-10 08:39:59Z

5

update tablename
set path = REPLICATE('x', len(path))

edited Apr 10, 2018 at 8:39

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

answered Apr 10, 2018 at 8:39

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

How to replace a string in a SQL Server Table Column with the same size of text

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related