Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2008-03-24 : 00:26:16
|
| Hello All,I have being trying to solve this problem for weeks know, but I think I'm very close in resolving it. The problem is that my data contains box like symbols in it. According to lookuptables.com the character representation for the box like character is #164. How would I find and delete the box like characters from my table?The list below is function or method that I have tried which did not work:- LTRIM and RTRIM- DECOMPOSE AND COMPOSE (The data is coming from an Oracle database)- Patindex-Changed the data type from char to the following: nvarchar, nchar, and ntext Thanks.Please advice |
|
|
Koji Matsumura
Posting Yak Master
141 Posts |
Posted - 2008-03-24 : 00:45:31
|
| Try REPLACE |
 |
|
|
|
|
|
How to delete Unicode symbols