Sunday 15 March 2015

sql - Removing White spaces from column -



sql - Removing White spaces from column -

i trying remove white spaces end of column. have tried doing ritrim, rtrim(ltrim(, ltrim(rtrim, , replace(descript,' ','') table has 600+ row , still returning spaces @ end.

a riego de retención* puntuación de participación (pa) se le dara cuando sea apropiado* perserveres when work difficult.                             *    absences affecting student's performance.                       *        

any other suggestions. in advance

you seek checking other blank characters other space(' ') tab('\t'),line feed('\n'),carriage homecoming ('\r'), this(i haven't tested it):

trim (' ' trim('\t' (trim('\n' trim('\r') your_column))))

sql

No comments:

Post a Comment