Unanswered: Repalce function for text column in ASE
Is there any function to search in a text column and replace tab characters to single space?
I am new to sybase ASE ( )and I would appreciate any help in this.
I have a table with few text columns and sometimes users put tab characters. When the bpc out and bcp in scrpit runs, the tab characters give a real problem and few records (with tab in text column) give error while bcp in. Due to client's restrictions, I cannot change the delimiter from tab to any other characters. Only solution is to search and replace tabs with space. Any script would be appreciated.