How do I replace a char with another char in a database field

Question

So this finds the bullet. I want to replace it with '*'

SELECT * FROM tblTrkRecordAction WHERE CHARINDEX(CHAR(0x0095), Comment) > 0

Possible duplicate of How to replace a string in a SQL Server Table Column — underscore_d
– underscore_d, Commented Nov 13, 2017 at 17:01

Tim Biegeleisen · Accepted Answer · 2017-11-13 17:00:50Z

1

Assuming you want to make this replacement in the comments field you could try this:

SELECT
    REPLACE(Comment, CHAR(0x0095), '*') AS new_comment
FROM tblTrkRecordAction
WHERE
    CHARINDEX(CHAR(0x0095), Comment) > 0;

answered Nov 13, 2017 at 17:00

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

1 Answer 1