![why](/static/img/x1mno0Ukhc-600.jpeg)
Sometimes it happens that you have unwanted tabs, line breaks, paragraphs, etc. in a table column. With the following code snippet you can clean the value of the column quickly:
[sql]update mytable
set mycolumn = REPLACE(REPLACE(REPLACE(mycolumn, ‘t’, ”), ‘r’, ”), ‘n’, ”)[/sql]