Home Forums SQL Server 2005 SQL Server 2005 General Discussion Insert a character in a string RE: Insert a character in a string

  • July 30, 2012 at 10:41 am

    #1519287

    I think the STUFF function is what you are looking for.

    declare @txt varchar(20) = 'RA99999-99'

    select STUFF(@txt, 3, 0, '0')