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

  • October 3, 2012 at 12:49 pm

    #1545160

    I used following to remove only trailing white spaces in a CHAR(30) column:

    RTRIM(LTRIM(CAST(City_Id As VARCHAR(30)))) AS City_Id

    Piyush Varma