Home Forums SQL Server 2005 Development Removing trailing spaces in a table column RE: Removing trailing spaces in a table column

  • January 22, 2008 at 2:56 am

    #770392

    LEN() function is NOT counting trailing spaces.

    DATALENGTH() does.

    Are you the spaces really are spaces (ascii value 32)?

    Make sure they are not hard-spaces (ascii value 160).

    N 56°04'39.16"
    E 12°55'05.25"