Hi
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 .
example
list
-----
abcd ..... chr(10) hidden character present
efgh
this is single record it should display abcdefgh
appreciate ur ideas.