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='
Remove the special character 'Æ' from the data
Posted - 06/11/2012 : 06:11:10
