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 4:20 am

    #770413

    Hi ,

    Fixed the issue 🙂 , the trailing space was in fact a carriage return , ascci value (13) , used a replace(queryphrase,char(13),'') to fix the issue .

    Guess where i went wrong was assuming there could only be spaces in the column.

    Jay

    Jayanth Kurup[/url]