remove 8th character in sequence of numbers + substring

• icampbell

  Right there with Babe

  Points: 770

  More actions

  August 2, 2010 at 4:16 am

  #238305

  :cool:i have a sequence of numbers beginning 00000001/01

  and want to remove the / in the sequence.

  Is there an easier way to do this other than concatinate two substring statements.

  Thanks,

  iain.

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  August 2, 2010 at 4:19 am

  #1200902

  DECLARE @STRING AS VARCHAR(8000)

  SET @STRING = '00000001/01'

  SET @STRING = REPLACE(@STRING, '/', '')

  PRINT @STRING

  ??

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---