Home Forums SQL Server 2008 T-SQL (SS2K8) SQL Server 2000 - Substring or replace for a binary value RE: SQL Server 2000 - Substring or replace for a binary value

  • October 2, 2012 at 3:19 pm

    #1544600

    your string = 0xF60F9125DBA7E94012F55E2177C95C0E906862B1

    try this in your SQL Statement

    REPLACE ( '0xF60F9125DBA7E94012F55E2177C95C0E906862B1' , '0x' , '' )

    Good Luck...