InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 16:40:27 GMT20http://www.sqlservercentral.com/Forums/Topic1367278-392-1.aspxThank you all for the responses. Substring and replace will not work on binary value unless we do the conversion to a string, did the conversion in the following way and it workedreplace(upper(master.dbo.fn_varbintohexstr('0xF60F9125DBA7E94012F55E2177C95C0E906862B1')),'0x','')Wed, 03 Oct 2012 07:59:38 GMTsvakkahttp://www.sqlservercentral.com/Forums/Topic1367278-392-1.aspxYou can use substring in SQL 2000Here is an example:declare @fg char(100)set @fg = '0xF60F9125DBA7E94012F55E2177C95C0E906862B1'select @fgselect substring(@fg, 3, 98)Tue, 02 Oct 2012 15:32:48 GMTpiotrkahttp://www.sqlservercentral.com/Forums/Topic1367278-392-1.aspxyour string = 0xF60F9125DBA7E94012F55E2177C95C0E906862B1try this in your SQL StatementREPLACE ( '0xF60F9125DBA7E94012F55E2177C95C0E906862B1' , '0x' , '' )Good Luck...Tue, 02 Oct 2012 15:19:40 GMTpchiragshttp://www.sqlservercentral.com/Forums/Topic1367278-392-1.aspxHow to substring or replace 0x from a binany value 0xF60F9125DBA7E94012F55E2177C95C0E906862B1in SQL Server 2000 using tsql. The output should be F60F9125DBA7E94012F55E2177C95C0E906862B1Tue, 02 Oct 2012 14:06:25 GMTsvakka