Home Forums SQL Server 2008 SQL Server 2008 - General SEPARATE WTH HYPHEN TO STRING again RE: SEPARATE WTH HYPHEN TO STRING again

  • August 17, 2012 at 12:17 am

    #1526910

    If you know positions you can use STUFF function:

    SELECT STUFF('AD675498IJU76', 5, 0, '-')

    SELECT STUFF(STUFF('AD675498IJU76', 5, 0, '-'), 8, 0, '-')

    SELECT STUFF(STUFF('AD675498IJU76', 5, 0, '-'), 9, 0, '-')

    --Vadim R.