Hi
i want to replace carriage return or new line with space in my one of the column of the database.
For this , i am using this query :
select replace(replace(Comments,chr(10),' '),chr(13),' ') FROM Comments_Master
Comments_Master is table name and Comments is column on which contains carriage return or new line.
But this query is not working as expected.
Once i run this query and again execute the query " select * FROM Comments_Master " , carriage return and new line still exist.
Please let me know what is problem with this query ?