MSSQL Value Replace Query

Discussion in 'Programming' started by crlfrancis, Jun 22, 2009.

0
  1. #1
    Hello
    I am trying to replace FFFFFF9C values to 00000000 in a warehouse table in column Items, I tried this query but nothing seem to changed.


    UPDATE Warehouse
    SET Items = CAST(REPLACE(Items, 'FFFFFF9C', '00000000') AS VARBINARY(1920))

    (8685 row(s) affected)

    Anyone can correct me?
     
    crlfrancis, Jun 22, 2009 IP