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