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