Wednesday, March 30, 2016

SQL-remove new line character from tables field


update TABLE_NAME
set COLUMN= replace(replace(COLUMN, CHR(13), ''), CHR(10), '')
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)