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 |
|
ankita.vinculum
Starting Member
5 Posts |
 Posted - 2012-06-11 : 06:11:10
|
| Hi,I have to remove the special character 'Æ' from my data, for this I have used the replace function - REPLACE(value,'Æ',CHAR(13)+CHAR(10)) but the next problem arrive i.e. If my data is like 'WorkRole =GaEquipmentWorkRoleÆSecurity Filter=GAEquipmnetÆDescription=' then REPLACE function also replaces all the a following e like 'WorkRole =G quipmentWorkRole Security Filter=G quipmnet Description=' so i required that function which only remove 'Æ' so that my data will appear as 'WorkRole =GaEquipmentWorkRole Security Filter=GAEquipmnet Description='ankita |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-06-11 : 06:30:35
|
| instead of a literal 'Æ', use its CHAR equivalent and see what happens.How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
ankita.vinculum
Starting Member
5 Posts |
Posted - 2012-06-11 : 06:32:26
|
| Hi,This is the solution for my problem :REPLACE(Value COLLATE Latin1_General_BIN,'Æ',CHAR(13)+CHAR(10))ankita |
|
|
|
|
|
|
Remove the special character 'Æ' from the data