Friday, December 14, 2018

Replace unwanted characters 



Select REPLACE(REPLACE(ColumnXXX, CHAR(13),' '), CHAR(10),' ')
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Postgress - Read a XML file from a postgress table XML column

SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...