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.