Need to edge out the competition for your dream job? Train for certifications today.
Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
;With cteNumbers as
Select ROW_NUMBER() Over(Order By c1.object_id) as N
From sys.system_columns c1, sys.system_columns c2
Select Distinct cmp_wwn
From cicmpy t
Join cteNumbers n ON n <= Len(cmp_note)
Where UNICODE(Substring(cmp_note, n.N, 1)) > 255
OR UNICODE(Substring(cmp_note, n.N, 1)) <> ASCII(Substring(cmp_note, n.N, 1))
Open in new window
>>So, I am looking for a way to remove the invalid characters so the sync will progress. <<
Ok, fair enough. Then you will have to identify all the invalid Xml characters.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.