Home Forums SQL Server 2008 SQL Server 2008 - General replace() remove the last character of some values RE: replace() remove the last character of some values

  • March 4, 2015 at 5:08 pm

    #1781803

    ScottPletcher (3/4/2015)

    LEFT(family, CHARINDEX('--', [family] + '--') - 2)

    Edit: Added the "- 2".

    when I add this, its removing the text before the [--].