Subquery returned more than 1 value. Replace single character on select

Question

How do I replace a character with multiple rows using update

UPDATE tbl_FMaster
SET PHOTO = (
        SELECT Replace(PHOTO, 'D:\', ' A : \ ') PHOTO
        FROM tbl_FMaster
        )

Answer 1

You don't need to use a subquery at all assuming you just want to run the REPLACE statement on the photo value in each row.

UPDATE tbl_FMaster
   SET photo = REPLACE( photo, 'D:\', 'A:\' );