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:32 pm

    #1544605

    You can use substring in SQL 2000

    Here is an example:

    declare @fg char(100)

    set @fg = '0xF60F9125DBA7E94012F55E2177C95C0E906862B1'

    select @fg

    select substring(@fg, 3, 98)