Home Forums SQL Server 2005 Development Using MAX and LTRIM, RTRIM together RE: Using MAX and LTRIM, RTRIM together

  • November 24, 2009 at 2:45 pm

    #1083693

    Slick84 (11/24/2009)

    I get all zeroes.

    CHARINDEX(CHAR(9), ItemNo, 0)

    Btw.. do I change the 9?

    Is "ItemNo" the right column name? Just wanted to make sure. 🙂