could you tell me sql statement to delete control characters like chr(10) chr(13) from a particular column . i don't want this to be replaced by space .
abcd ..... chr(10) hidden character present
this is single record it should display abcdefgh
appreciate ur ideas.